APPS.PON_UDA_IMPORT_PKG dependencies on PO_UDA_INTERFACE

Line 25: -- EGO_USER_ATTR_ROW_TABLE, EGO_COL_NAME_VALUE_PAIR_ARRAY from the data in the interface table PO_UDA_INTERFACE

21: --Start of Comments
22: --Name: POPULATE_STRUCTURES
23: --Procedure:
24: -- This procedure populates the structures EGO_COL_NAME_VALUE_PAIR_ARRAY, EGO_USER_ATTR_DATA_TABLE,
25: -- EGO_USER_ATTR_ROW_TABLE, EGO_COL_NAME_VALUE_PAIR_ARRAY from the data in the interface table PO_UDA_INTERFACE
26: --Parameters:
27: --IN:
28: -- 1. p_attr_grp_type
29: -- The attribute Group Type (Entity Type)

Line 166: FROM PO_UDA_INTERFACE

162: ,CREATED_BY_NAME
163: ,LAST_UPDATED_BY_NAME
164: ,INTERFACE_SOURCE_CODE
165: ,INTERFACE_SOURCE_LINE_ID
166: FROM PO_UDA_INTERFACE
167: WHERE PROCESS_STATUS = PON_UDA_IMPORT_PKG.IN_PROGRESS
168: AND NVL(PK1_VALUE, -999) = NVL(p_pk1_value, -999)
169: AND NVL(PK2_VALUE, -999) = NVL(p_pk2_value, -999)
170: AND NVL(PK3_VALUE, -999) = NVL(p_pk3_value, -999)

Line 203: FROM PO_UDA_INTERFACE

199: BEGIN
200: d_progress := 30;
201: SELECT INTERFACE_REFERENCE_ID
202: INTO g_interface_reference_id
203: FROM PO_UDA_INTERFACE
204: WHERE NVL(PK1_VALUE, -999) = NVL(p_pk1_value, -999)
205: AND NVL(PK2_VALUE, -999) = NVL(p_pk2_value, -999)
206: AND NVL(PK3_VALUE, -999) = NVL(p_pk3_value, -999)
207: AND NVL(PK4_VALUE, -999) = NVL(p_pk4_value, -999)

Line 567: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL

563: EXIT WHEN cur_uda_attributes%NOTFOUND;
564:
565: d_progress := 110;
566: BEGIN
567: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
568: INTO l_user_row_identifier
569: FROM DUAL;
570: d_progress := 110;
571: PON_UDA_IMPORT_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);

Line 950: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL

946: PON_UDA_IMPORT_PKG.DEBUG('Usage type is ADDRESS', d_progress);
947: FOR cur_address_rec IN cur_address(p_address_lookup_type) LOOP
948: BEGIN
949: d_progress := 400;
950: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
951: INTO l_row_identifier
952: FROM DUAL;
953:
954: d_progress := 410;

Line 993: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL

989: EXIT WHEN cur_uda_attributes%NOTFOUND;
990:
991: BEGIN
992: d_progress := 460;
993: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
994: INTO l_user_row_identifier
995: FROM DUAL;
996:
997: d_progress := 470;

Line 1042: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL

1038: ELSE -- FOR NON ADDRESS AGS
1039: d_progress := 570;
1040: BEGIN
1041: d_progress := 580;
1042: SELECT PO_UDA_INTERFACE_ROW_ID_S.NEXTVAL
1043: INTO l_row_identifier
1044: FROM DUAL;
1045: d_progress := 590;
1046: PON_UDA_IMPORT_PKG.DEBUG('l_row_identifier : ' || l_row_identifier, d_progress);

Line 1085: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL

1081:
1082: d_progress := 640;
1083: BEGIN
1084: d_progress := 650;
1085: SELECT PO_UDA_INTERFACE_USER_ROW_ID_S.NEXTVAL
1086: INTO l_user_row_identifier
1087: FROM DUAL;
1088: d_progress := 660;
1089: PON_UDA_IMPORT_PKG.DEBUG('l_user_row_identifier : ' || l_user_row_identifier, d_progress);

Line 2206: UPDATE PO_UDA_INTERFACE

2202: WHEN OTHERS THEN
2203: l_err_txt := 'Exception in IMPORT_UDA_ATTRS with ERROR : ' || SQLERRM;
2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2205:
2206: UPDATE PO_UDA_INTERFACE
2207: SET PK1_VALUE = NULL, PK2_VALUE=NULL, PROCESS_STATUS = 1, PROCESS_PHASE = NULL
2208: WHERE PK1_VALUE = p_pk1_value;
2209:
2210: PON_UDA_IMPORT_PKG.HANDLE_ERROR

Line 2260: UPDATE PO_UDA_INTERFACE

2256: )
2257: IS
2258: BEGIN
2259: IF p_process_status IN (PON_UDA_IMPORT_PKG.PENDING, PON_UDA_IMPORT_PKG.IN_PROGRESS, PON_UDA_IMPORT_PKG.COMPLETED) THEN
2260: UPDATE PO_UDA_INTERFACE
2261: SET PROCESS_STATUS = p_process_status
2262: ,PROCESS_PHASE = p_process_phase
2263: WHERE NVL(PK1_VALUE, -999) = NVL(p_pk1_value, -999)
2264: AND NVL(PK2_VALUE, -999) = NVL(p_pk2_value, -999)