APPS.PSA_BC_XLA_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1158: ELSIF p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' THEN

1154: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN
1155: SELECT min(creation_date) INTO l_dist_creation_date
1156: FROM po_req_distributions_all
1157: WHERE distribution_id = p_distribution_id;
1158: ELSIF p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' THEN
1159: SELECT min(creation_date) INTO l_dist_creation_date
1160: FROM po_distributions_all
1161: WHERE po_distribution_id = p_distribution_id;
1162: ELSIF p_dist_link_type = 'AP_INV_DIST' THEN

Line 1160: FROM po_distributions_all

1156: FROM po_req_distributions_all
1157: WHERE distribution_id = p_distribution_id;
1158: ELSIF p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' THEN
1159: SELECT min(creation_date) INTO l_dist_creation_date
1160: FROM po_distributions_all
1161: WHERE po_distribution_id = p_distribution_id;
1162: ELSIF p_dist_link_type = 'AP_INV_DIST' THEN
1163: SELECT min(creation_date) INTO l_dist_creation_date
1164: FROM ap_invoice_distributions_all

Line 1173: IF (p_dist_link_type <> 'PO_DISTRIBUTIONS_ALL') then

1169: END IF;
1170:
1171: psa_utils.debug_other_string(g_state_level,l_path_name,'Distribution CREATION_DATE = ' || to_char(l_dist_creation_date));
1172:
1173: IF (p_dist_link_type <> 'PO_DISTRIBUTIONS_ALL') then
1174: if (l_dist_creation_date > l_r12_upgrade_date) OR (l_dist_creation_date IS NULL) THEN
1175: l_return_val := 'N';
1176: End if;
1177: END IF;

Line 1178: --IF (p_dist_link_type ='PO_DISTRIBUTIONS_ALL' OR l_dist_creation_date <= l_r12_upgrade_date) THEN

1174: if (l_dist_creation_date > l_r12_upgrade_date) OR (l_dist_creation_date IS NULL) THEN
1175: l_return_val := 'N';
1176: End if;
1177: END IF;
1178: --IF (p_dist_link_type ='PO_DISTRIBUTIONS_ALL' OR l_dist_creation_date <= l_r12_upgrade_date) THEN
1179: IF (l_dist_creation_date <= l_r12_upgrade_date) THEN
1180: OPEN c_check(p_application_id,
1181: p_entity_code,
1182: p_source_id_int_1,

Line 1190: IF (p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' ) THEN

1186: CLOSE c_check;
1187: psa_utils.debug_other_string(g_state_level,l_path_name,'l_check_variable = ' || l_check_variable);
1188: IF l_check_variable ='1' THEN
1189: -- Following IF added for Bug 7598349
1190: IF (p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' ) THEN
1191: OPEN c_po_upg_chk(p_application_id,
1192: p_entity_code,
1193: p_source_id_int_1,
1194: p_dist_link_type,

Line 1209: END IF; -- p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' inner

1205: l_return_val := 'N';
1206: END IF;
1207: ELSE
1208: l_return_val := 'N'; --this means data exists in sla and is a R12 entry
1209: END IF; -- p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' inner
1210: ELSE -- if l_check_variable
1211: IF FV_INSTALL.ENABLED THEN
1212: l_return_val := 'O'; --Make use of Upgrade tab in JLD form
1213: ELSE