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.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_I_PARTIES

Line 91: FROM csi_i_parties

87:
88: BEGIN
89: SELECT instance_party_id
90: INTO l_inst_party_id
91: FROM csi_i_parties
92: WHERE instance_id = p_instance_id
93: and party_source_table = p_party_source_table
94: and party_id = p_party_id
95: and relationship_type_code = p_relationship_type

Line 135: FROM csi_i_parties

131: l_return_value BOOLEAN := TRUE;
132: BEGIN
133: SELECT 'x'
134: INTO l_dummy
135: FROM csi_i_parties
136: WHERE instance_party_id = p_Instance_party_id;
137: IF ( p_stack_err_msg = TRUE ) THEN
138: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
139: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_id);

Line 371: FROM csi_i_parties cip,

367:
368: CURSOR C1( i_inst_party_id IN NUMBER)IS
369: SELECT cip.party_id,
370: cip.party_source_table
371: FROM csi_i_parties cip,
372: csi_item_instances cii
373: WHERE cip.instance_party_id = i_inst_party_id
374: AND cip.instance_id = cii.instance_id
375: AND ((cip.active_end_date IS NULL) OR (cip.active_end_date >= SYSDATE));

Line 650: FROM csi_i_parties

646: l_return_value BOOLEAN := TRUE;
647:
648: CURSOR C1 is
649: SELECT instance_party_id
650: FROM csi_i_parties
651: WHERE contact_ip_id = p_instance_party_id
652: AND ((active_end_date is null) or (active_end_date > sysdate));
653:
654: CURSOR C2 is

Line 664: FROM csi_i_parties_h s,

660: BEGIN
661:
662: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
663: INTO l_transaction_date
664: FROM csi_i_parties_h s,
665: csi_transactions t
666: WHERE s.instance_party_id=p_instance_party_id
667: AND s.transaction_id=t.transaction_id
668: AND t.transaction_id <>nvl(p_txn_id, -99999);

Line 684: FROM csi_i_parties_h s,

680: FETCH C1 into l_contact_temp;
681: IF C1%FOUND then
682: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
683: INTO l_transaction_date
684: FROM csi_i_parties_h s,
685: csi_transactions t
686: WHERE s.instance_party_id=l_contact_temp
687: AND s.transaction_id=t.transaction_id
688: AND t.transaction_id <> nvl(p_txn_id, -99999);

Line 744: FROM csi_i_parties

740: l_inst_party_id NUMBER;
741:
742: CURSOR C1 IS
743: SELECT 'x'
744: FROM csi_i_parties
745: WHERE instance_id = p_Instance_id
746: AND instance_party_id <> l_inst_party_id -- Ignore the current instance_party_id
747: AND relationship_type_code = 'OWNER'
748: and ((active_end_date is null) OR (active_end_date >= sysdate));

Line 786: SELECT CSI_I_PARTIES_S.nextval

782:
783: l_inst_party_id NUMBER;
784:
785: BEGIN
786: SELECT CSI_I_PARTIES_S.nextval
787: INTO l_inst_party_id
788: FROM sys.dual;
789: RETURN l_inst_party_id;
790: END gen_inst_party_id;

Line 802: SELECT CSI_I_PARTIES_H_S.nextval

798: FUNCTION gen_inst_party_hist_id
799: RETURN NUMBER IS
800: l_inst_party_his_id NUMBER;
801: BEGIN
802: SELECT CSI_I_PARTIES_H_S.nextval
803: INTO l_inst_party_his_id
804: FROM sys.dual;
805: RETURN l_inst_party_his_id ;
806: END gen_inst_party_hist_id;

Line 923: FROM csi_i_parties

919:
920: BEGIN
921: SELECT instance_party_id
922: INTO l_inst_party_id
923: FROM csi_i_parties
924: WHERE instance_party_id = p_Instance_party_id;
925: RETURN l_return_value;
926: EXCEPTION
927: WHEN NO_DATA_FOUND THEN

Line 935: /* exists in csi_i_parties */

931:
932: /*-----------------------------------------------------------*/
933: /* Procedure name: Is_Inst_partyID_Valid */
934: /* Description : Check if the instance_party_id */
935: /* exists in csi_i_parties */
936: /*-----------------------------------------------------------*/
937:
938: FUNCTION Is_Inst_partyID_Valid
939: (

Line 953: FROM csi_i_parties

949:
950: BEGIN
951: SELECT instance_id
952: INTO l_instance_id
953: FROM csi_i_parties
954: WHERE instance_party_id = p_Instance_party_id
955: AND ((active_end_date is null) OR (active_end_date >= sysdate));
956: --
957: -- srramakr Instance ID validation added for bug # 2477417.

Line 972: FROM csi_i_parties

968: -- Check for the existence of instance_party_id in the database.
969: BEGIN
970: SELECT instance_id
971: INTO l_instance_id
972: FROM csi_i_parties
973: WHERE instance_party_id = p_Instance_party_id;
974: EXCEPTION
975: WHEN NO_DATA_FOUND THEN
976: l_return_value := FALSE;

Line 1029: FROM csi_i_parties

1025:
1026: CURSOR C3(i_inst_party_id NUMBER) IS
1027: SELECT party_id,
1028: party_source_table
1029: FROM csi_i_parties
1030: WHERE instance_party_id = i_inst_party_id
1031: AND ((active_end_date is null) OR (active_end_date >= sysdate));
1032:
1033:

Line 1049: FROM csi_i_parties

1045: SELECT party_id,
1046: party_source_table
1047: INTO l_party_id,
1048: l_party_source_table
1049: FROM csi_i_parties
1050: WHERE instance_party_id = p_instance_party_id;
1051: EXCEPTION
1052: WHEN NO_DATA_FOUND THEN
1053: l_return_value := FALSE;

Line 1163: FROM csi_i_parties

1159: l_return_value BOOLEAN := TRUE;
1160:
1161: CURSOR c1 IS
1162: SELECT active_start_date
1163: FROM csi_i_parties
1164: WHERE instance_party_id = p_instance_party_id
1165: and ((active_end_date is null) OR (active_end_date >= sysdate));
1166: BEGIN
1167: IF (p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE) THEN

Line 1227: FROM csi_i_parties

1223: l_return_value BOOLEAN := TRUE;
1224:
1225: CURSOR c1 IS
1226: SELECT active_end_date
1227: FROM csi_i_parties
1228: WHERE instance_party_id = p_inst_party_id
1229: and ((active_end_date is null) OR (active_end_date >= sysdate));
1230: BEGIN
1231: IF p_end_date is NOT NULL THEN

Line 1282: FROM csi_i_parties

1278: l_transaction_date DATE;
1279:
1280: CURSOR c1 IS
1281: SELECT active_end_date
1282: FROM csi_i_parties
1283: WHERE instance_party_id = p_inst_party_id
1284: and ((active_end_date is null) OR (active_end_date >= sysdate));
1285: BEGIN
1286: IF ((p_ip_account_id IS NULL) OR (p_ip_account_id = FND_API.G_MISS_NUM))

Line 1873: FROM csi_i_parties

1869:
1870: BEGIN
1871: SELECT instance_party_id
1872: INTO l_inst_party_id
1873: FROM csi_i_parties
1874: WHERE contact_ip_id = p_contact_ip_id
1875: AND contact_flag = 'Y';
1876:
1877: l_return_value := FALSE;

Line 1911: FROM csi_i_parties

1907: l_rel_type_code VARCHAR2(30);
1908: BEGIN
1909: SELECT relationship_type_code
1910: INTO l_rel_type_code
1911: FROM csi_i_parties
1912: WHERE instance_party_id = p_Instance_party_id;
1913: RETURN l_rel_type_code;
1914: EXCEPTION
1915: WHEN NO_DATA_FOUND THEN

Line 1995: FROM csi_i_parties

1991: p_party_rec.attribute15 ,
1992: p_party_rec.object_version_number ,
1993: p_party_rec.primary_flag ,
1994: p_party_rec.preferred_flag
1995: FROM csi_i_parties
1996: WHERE instance_party_id = p_Instance_party_id;
1997: RETURN TRUE;
1998: EXCEPTION
1999: WHEN NO_DATA_FOUND THEN

Line 2133: FROM csi_i_parties

2129: BEGIN
2130:
2131: SELECT 'x'
2132: INTO l_dummy
2133: FROM csi_i_parties
2134: WHERE instance_id = p_party_rec.instance_id
2135: AND party_source_table = p_party_rec.party_source_table
2136: AND party_id = p_party_rec.party_id
2137: AND relationship_type_code = p_party_rec.relationship_type_code

Line 2399: FROM csi_i_parties

2395: l_return_value BOOLEAN := TRUE;
2396:
2397: CURSOR C1 IS
2398: SELECT 'x'
2399: FROM csi_i_parties
2400: WHERE instance_id = p_Instance_id
2401: -- AND relationship_type_code = p_relationship_type
2402: AND preferred_flag = 'Y'
2403: AND contact_flag = 'Y'

Line 2448: FROM csi_i_parties

2444: l_return_value BOOLEAN := TRUE;
2445:
2446: CURSOR C1 IS
2447: SELECT 'x'
2448: FROM csi_i_parties
2449: WHERE instance_id = p_Instance_id
2450: AND relationship_type_code = p_relationship_type
2451: AND primary_flag = 'Y'
2452: AND contact_flag = 'Y'

Line 2497: FROM csi_i_parties

2493: l_return_value BOOLEAN := TRUE;
2494:
2495: CURSOR C1 IS
2496: SELECT 'x'
2497: FROM csi_i_parties
2498: WHERE instance_id = p_Instance_id
2499: -- AND relationship_type_code = p_relationship_type
2500: AND preferred_flag = 'Y'
2501: AND contact_flag <> 'Y'

Line 2547: FROM csi_i_parties

2543: l_return_value BOOLEAN := TRUE;
2544:
2545: CURSOR C1 IS
2546: SELECT 'x'
2547: FROM csi_i_parties
2548: WHERE instance_id = p_Instance_id
2549: AND relationship_type_code = p_relationship_type
2550: AND primary_flag = 'Y'
2551: AND contact_flag <> 'Y'