DBA Data[Home] [Help]

APPS.PO_ACCOUNT_HELPER dependencies on PO_TBL_VARCHAR2000

Line 522: X_RETURN_MESSAGE OUT NOCOPY PO_TBL_VARCHAR2000,

518: P_CHANGE_STAT_TBL IN PO_TBL_VARCHAR30,
519: P_REGEN_Y_N IN VARCHAR2,
520: X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,
521: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
522: X_RETURN_MESSAGE OUT NOCOPY PO_TBL_VARCHAR2000,
523: X_MESSAGE_TOKEN OUT NOCOPY PO_TBL_VARCHAR2000) IS
524: l_charge_count NUMBER;
525: l_acrn_code NUMBER := 1;
526: l_return_status varchar2(1);

Line 523: X_MESSAGE_TOKEN OUT NOCOPY PO_TBL_VARCHAR2000) IS

519: P_REGEN_Y_N IN VARCHAR2,
520: X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,
521: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
522: X_RETURN_MESSAGE OUT NOCOPY PO_TBL_VARCHAR2000,
523: X_MESSAGE_TOKEN OUT NOCOPY PO_TBL_VARCHAR2000) IS
524: l_charge_count NUMBER;
525: l_acrn_code NUMBER := 1;
526: l_return_status varchar2(1);
527: l_return_message varchar2(2000);

Line 532: l_error_message PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

528: l_approved_flag VARCHAR2(1);
529: l_doc_type varchar2(30);
530: x_error VARCHAR2(1300);
531: l_dist_id NUMBER;
532: l_error_message PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
533: l_message_token PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
534: l_token varchar2(2000);
535: l_dist_count number;
536: l_key NUMBER;

Line 533: l_message_token PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

529: l_doc_type varchar2(30);
530: x_error VARCHAR2(1300);
531: l_dist_id NUMBER;
532: l_error_message PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
533: l_message_token PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
534: l_token varchar2(2000);
535: l_dist_count number;
536: l_key NUMBER;
537: l_ACRN_TBL PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

Line 2001: X_RETURN_MESSAGE OUT NOCOPY PO_TBL_VARCHAR2000,

1997: P_CHANGE_STAT_TBL IN PO_TBL_VARCHAR30,
1998: P_REGEN_Y_N IN VARCHAR2,
1999: X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,
2000: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2001: X_RETURN_MESSAGE OUT NOCOPY PO_TBL_VARCHAR2000,
2002: X_MESSAGE_TOKEN OUT NOCOPY PO_TBL_VARCHAR2000)
2003: IS
2004:
2005: d_api_name CONSTANT VARCHAR2(30) := 'BUILD_ACRN_WRAP';

Line 2002: X_MESSAGE_TOKEN OUT NOCOPY PO_TBL_VARCHAR2000)

1998: P_REGEN_Y_N IN VARCHAR2,
1999: X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,
2000: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2001: X_RETURN_MESSAGE OUT NOCOPY PO_TBL_VARCHAR2000,
2002: X_MESSAGE_TOKEN OUT NOCOPY PO_TBL_VARCHAR2000)
2003: IS
2004:
2005: d_api_name CONSTANT VARCHAR2(30) := 'BUILD_ACRN_WRAP';
2006: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 2018: L_RETURN_MESSAGE PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

2014:
2015: O_ACRN_TBL PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
2016: N_ACRN_TBL PO_TBL_VARCHAR30;
2017: L_RETURN_STATUS VARCHAR2(22) := '';
2018: L_RETURN_MESSAGE PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2019: L_MESSAGE_TOKEN PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2020: l_charge_count NUMBER;
2021: l_acrn_code NUMBER := 1;
2022:

Line 2019: L_MESSAGE_TOKEN PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

2015: O_ACRN_TBL PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
2016: N_ACRN_TBL PO_TBL_VARCHAR30;
2017: L_RETURN_STATUS VARCHAR2(22) := '';
2018: L_RETURN_MESSAGE PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2019: L_MESSAGE_TOKEN PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2020: l_charge_count NUMBER;
2021: l_acrn_code NUMBER := 1;
2022:
2023: l_approved_flag VARCHAR2(1);

Line 2027: l_error_message PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();

2023: l_approved_flag VARCHAR2(1);
2024: l_doc_type varchar2(30);
2025: x_error VARCHAR2(1300);
2026: l_dist_id NUMBER;
2027: l_error_message PO_TBL_VARCHAR2000 := PO_TBL_VARCHAR2000();
2028: l_token varchar2(2000);
2029: l_dist_count number;
2030: l_key NUMBER;
2031: l_ACRN_TBL PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();