eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_ACCOUNT_HELPER dependencies on PO_TBL_VARCHAR30

Line 516: P_ACRN_TBL IN PO_TBL_VARCHAR30,

512: /*ACRN REFACTORING CHANGES BEGIN*/
513: PROCEDURE BUILD_ACRN(p_header_id IN NUMBER,
514: P_DIST_ID_TBL IN PO_TBL_NUMBER,
515: P_CODE_ID_TBL IN PO_TBL_NUMBER,
516: P_ACRN_TBL IN PO_TBL_VARCHAR30,
517: P_LOA_TBL IN PO_TBL_VARCHAR30,
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,

Line 517: P_LOA_TBL IN PO_TBL_VARCHAR30,

513: PROCEDURE BUILD_ACRN(p_header_id IN NUMBER,
514: P_DIST_ID_TBL IN PO_TBL_NUMBER,
515: P_CODE_ID_TBL IN PO_TBL_NUMBER,
516: P_ACRN_TBL IN PO_TBL_VARCHAR30,
517: P_LOA_TBL IN PO_TBL_VARCHAR30,
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,

Line 518: P_CHANGE_STAT_TBL IN PO_TBL_VARCHAR30,

514: P_DIST_ID_TBL IN PO_TBL_NUMBER,
515: P_CODE_ID_TBL IN PO_TBL_NUMBER,
516: P_ACRN_TBL IN PO_TBL_VARCHAR30,
517: P_LOA_TBL IN PO_TBL_VARCHAR30,
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,

Line 520: X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,

516: P_ACRN_TBL IN PO_TBL_VARCHAR30,
517: P_LOA_TBL IN PO_TBL_VARCHAR30,
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;

Line 537: l_ACRN_TBL PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

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();
538:
539: BEGIN
540:
541: --Finding out if the whether the it is an award or modification.

Line 1995: P_ACRN_TBL IN PO_TBL_VARCHAR30,

1991:
1992: PROCEDURE BUILD_ACRN_WRAP(p_header_id IN NUMBER,
1993: P_DIST_ID_TBL IN PO_TBL_NUMBER,
1994: P_CODE_ID_TBL IN PO_TBL_NUMBER,
1995: P_ACRN_TBL IN PO_TBL_VARCHAR30,
1996: P_LOA_TBL IN PO_TBL_VARCHAR30,
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,

Line 1996: P_LOA_TBL IN PO_TBL_VARCHAR30,

1992: PROCEDURE BUILD_ACRN_WRAP(p_header_id IN NUMBER,
1993: P_DIST_ID_TBL IN PO_TBL_NUMBER,
1994: P_CODE_ID_TBL IN PO_TBL_NUMBER,
1995: P_ACRN_TBL IN PO_TBL_VARCHAR30,
1996: P_LOA_TBL IN PO_TBL_VARCHAR30,
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,

Line 1997: P_CHANGE_STAT_TBL IN PO_TBL_VARCHAR30,

1993: P_DIST_ID_TBL IN PO_TBL_NUMBER,
1994: P_CODE_ID_TBL IN PO_TBL_NUMBER,
1995: P_ACRN_TBL IN PO_TBL_VARCHAR30,
1996: P_LOA_TBL IN PO_TBL_VARCHAR30,
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,

Line 1999: X_ACRN_TBL OUT NOCOPY PO_TBL_VARCHAR30,

1995: P_ACRN_TBL IN PO_TBL_VARCHAR30,
1996: P_LOA_TBL IN PO_TBL_VARCHAR30,
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

Line 2011: L_LOA_TBL PO_TBL_VARCHAR30 ;

2007: d_position NUMBER;
2008:
2009: L_DIST_ID_TBL PO_TBL_NUMBER ;
2010: L_CODE_ID_TBL PO_TBL_NUMBER ;
2011: L_LOA_TBL PO_TBL_VARCHAR30 ;
2012: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
2013: L_ACRN VARCHAR2(2) :='';
2014:
2015: O_ACRN_TBL PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

Line 2012: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;

2008:
2009: L_DIST_ID_TBL PO_TBL_NUMBER ;
2010: L_CODE_ID_TBL PO_TBL_NUMBER ;
2011: L_LOA_TBL PO_TBL_VARCHAR30 ;
2012: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
2013: L_ACRN VARCHAR2(2) :='';
2014:
2015: O_ACRN_TBL PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
2016: N_ACRN_TBL PO_TBL_VARCHAR30;

Line 2015: O_ACRN_TBL PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

2011: L_LOA_TBL PO_TBL_VARCHAR30 ;
2012: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
2013: L_ACRN VARCHAR2(2) :='';
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();

Line 2016: N_ACRN_TBL PO_TBL_VARCHAR30;

2012: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
2013: L_ACRN VARCHAR2(2) :='';
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;

Line 2031: l_ACRN_TBL PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();

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();
2032: l_count NUMBER;
2033:
2034:
2035: BEGIN