APPS.CSI_ML_UPDATE_PVT dependencies on DUAL

Line 740: FROM DUAL;

736: x_instance_tbl(inst_idx).check_for_instance_expiry,
737: x_instance_tbl(inst_idx).instance_description,
738: x_instance_tbl(inst_idx).external_reference,
739: x_instance_tbl(inst_idx).operational_status_code
740: FROM DUAL;
741:
742: x_instance_tbl(inst_idx).INTERFACE_ID := inst_intf_rec.inst_interface_id;
743:
744: ---Populate Pricing attribites

Line 1687: FROM DUAL;

1683: x_price_tbl(price_idx).attribute13,
1684: x_price_tbl(price_idx).attribute14,
1685: x_price_tbl(price_idx).attribute15,
1686: x_price_tbl(price_idx).object_version_number
1687: FROM DUAL;
1688: END IF;
1689:
1690:
1691: ---Populate Org Assignments

Line 1767: FROM DUAL;

1763: x_org_assign_tbl(org_idx).attribute13,
1764: x_org_assign_tbl(org_idx).attribute14,
1765: x_org_assign_tbl(org_idx).attribute15,
1766: x_org_assign_tbl(org_idx).object_version_number
1767: FROM DUAL;
1768: END IF; --Org Assignments
1769:
1770:
1771: ----Populate Party

Line 1955: FROM DUAL;

1951: x_party_tbl (prty_idx).attribute13,
1952: x_party_tbl (prty_idx).attribute14,
1953: x_party_tbl (prty_idx).attribute15,
1954: x_party_tbl (prty_idx).object_version_number
1955: FROM DUAL;
1956:
1957: x_party_tbl (prty_idx).parent_tbl_index:=inst_idx;
1958: IF (x_party_tbl(prty_idx).contact_flag = 'Y'
1959: AND x_party_tbl(prty_idx).contact_ip_id IS NULL)

Line 2146: FROM DUAL;

2142: x_account_tbl (ptyacc_idx).attribute14,
2143: x_account_tbl (ptyacc_idx).attribute15,
2144: x_account_tbl (ptyacc_idx).call_contracts,
2145: x_account_tbl (ptyacc_idx).vld_organization_id
2146: FROM DUAL;
2147: END IF; ---party_account1
2148:
2149: ---Populate Party Account2
2150: IF party_intf_rec.party_account2_id IS NOT NULL

Line 2326: FROM DUAL;

2322: x_account_tbl (ptyacc_idx).attribute14,
2323: x_account_tbl (ptyacc_idx).attribute15,
2324: x_account_tbl (ptyacc_idx).call_contracts,
2325: x_account_tbl (ptyacc_idx).vld_organization_id
2326: FROM DUAL;
2327: END IF; ---party_account2
2328:
2329: ---Populate Party Account3
2330: IF party_intf_rec.party_account3_id IS NOT NULL

Line 2506: FROM DUAL;

2502: x_account_tbl (ptyacc_idx).attribute14,
2503: x_account_tbl (ptyacc_idx).attribute15,
2504: x_account_tbl (ptyacc_idx).call_contracts,
2505: x_account_tbl (ptyacc_idx).vld_organization_id
2506: FROM DUAL;
2507: END IF; ---party_account3
2508:
2509: IF party_intf_rec.contact_party_id IS NOT NULL AND
2510: party_intf_rec.contact_party_id <> fnd_api.g_miss_num

Line 2618: FROM DUAL;

2614: x_ext_attrib_value_tbl (extatt_idx).attribute13,
2615: x_ext_attrib_value_tbl (extatt_idx).attribute14,
2616: x_ext_attrib_value_tbl (extatt_idx).attribute15,
2617: x_ext_attrib_value_tbl (extatt_idx).object_version_number
2618: FROM DUAL;
2619: END LOOP; ---ext_attrib_intf_cur
2620:
2621: --bnarayan added for R12
2622: -- Populate asset records