DBA Data[Home] [Help]

APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_TBL_VARCHAR30

Line 1691: L_ACRN_TBL PO_TBL_VARCHAR30;

1687: )
1688: IS
1689: L_DIST_ID_TBL PO_TBL_NUMBER;
1690: L_CHARGE_ACC_TBL PO_TBL_NUMBER;
1691: L_ACRN_TBL PO_TBL_VARCHAR30;
1692: X_ACRN_TBL PO_TBL_VARCHAR30;
1693: X_RETURN_STATUS VARCHAR2(1);
1694: X_RETURN_MESSAGE PO_TBL_VARCHAR2000;
1695: X_MESSAGE_TOKEN PO_TBL_VARCHAR2000;

Line 1692: X_ACRN_TBL PO_TBL_VARCHAR30;

1688: IS
1689: L_DIST_ID_TBL PO_TBL_NUMBER;
1690: L_CHARGE_ACC_TBL PO_TBL_NUMBER;
1691: L_ACRN_TBL PO_TBL_VARCHAR30;
1692: X_ACRN_TBL PO_TBL_VARCHAR30;
1693: X_RETURN_STATUS VARCHAR2(1);
1694: X_RETURN_MESSAGE PO_TBL_VARCHAR2000;
1695: X_MESSAGE_TOKEN PO_TBL_VARCHAR2000;
1696: L_PROGRESS VARCHAR2(3) := '000';

Line 1700: L_LOA_TBL PO_TBL_VARCHAR30;

1696: L_PROGRESS VARCHAR2(3) := '000';
1697: L_API_NAME VARCHAR2(30) := 'DEFAULT_ACRN_VALUES';
1698: L_MODULE VARCHAR2(40) := 'PO.PLSQL.PO_LINK_REQ_DIST_PVT';
1699: --ACRN CHANGES Bug 13541656
1700: L_LOA_TBL PO_TBL_VARCHAR30;
1701: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
1702: BEGIN
1703:
1704: SELECT DISTINCT PO_DISTRIBUTION_ID, CODE_COMBINATION_ID, '',CLM_MISC_LOA,'NEW'

Line 1701: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;

1697: L_API_NAME VARCHAR2(30) := 'DEFAULT_ACRN_VALUES';
1698: L_MODULE VARCHAR2(40) := 'PO.PLSQL.PO_LINK_REQ_DIST_PVT';
1699: --ACRN CHANGES Bug 13541656
1700: L_LOA_TBL PO_TBL_VARCHAR30;
1701: L_CHANGE_STAT_TBL PO_TBL_VARCHAR30;
1702: BEGIN
1703:
1704: SELECT DISTINCT PO_DISTRIBUTION_ID, CODE_COMBINATION_ID, '',CLM_MISC_LOA,'NEW'
1705: BULK COLLECT INTO L_DIST_ID_TBL, L_CHARGE_ACC_TBL, L_ACRN_TBL,