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 373: FROM csi_i_parties cip,

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

Line 652: FROM csi_i_parties

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

Line 666: FROM csi_i_parties_h s,

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

Line 686: FROM csi_i_parties_h s,

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

Line 746: FROM csi_i_parties

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

Line 788: SELECT CSI_I_PARTIES_S.nextval

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

Line 804: SELECT CSI_I_PARTIES_H_S.nextval

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

Line 925: FROM csi_i_parties

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

Line 937: /* exists in csi_i_parties */

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

Line 955: FROM csi_i_parties

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

Line 974: FROM csi_i_parties

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

Line 1031: FROM csi_i_parties

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

Line 1051: FROM csi_i_parties

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

Line 1165: FROM csi_i_parties

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

Line 1231: FROM csi_i_parties

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

Line 1286: FROM csi_i_parties

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

Line 1877: FROM csi_i_parties

1873:
1874: BEGIN
1875: SELECT instance_party_id
1876: INTO l_inst_party_id
1877: FROM csi_i_parties
1878: WHERE contact_ip_id = p_contact_ip_id
1879: AND contact_flag = 'Y';
1880:
1881: l_return_value := FALSE;

Line 1915: FROM csi_i_parties

1911: l_rel_type_code VARCHAR2(30);
1912: BEGIN
1913: SELECT relationship_type_code
1914: INTO l_rel_type_code
1915: FROM csi_i_parties
1916: WHERE instance_party_id = p_Instance_party_id;
1917: RETURN l_rel_type_code;
1918: EXCEPTION
1919: WHEN NO_DATA_FOUND THEN

Line 1999: FROM csi_i_parties

1995: p_party_rec.attribute15 ,
1996: p_party_rec.object_version_number ,
1997: p_party_rec.primary_flag ,
1998: p_party_rec.preferred_flag
1999: FROM csi_i_parties
2000: WHERE instance_party_id = p_Instance_party_id;
2001: RETURN TRUE;
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN

Line 2137: FROM csi_i_parties

2133: BEGIN
2134:
2135: SELECT 'x'
2136: INTO l_dummy
2137: FROM csi_i_parties
2138: WHERE instance_id = p_party_rec.instance_id
2139: AND party_source_table = p_party_rec.party_source_table
2140: AND party_id = p_party_rec.party_id
2141: AND relationship_type_code = p_party_rec.relationship_type_code

Line 2403: FROM csi_i_parties

2399: l_return_value BOOLEAN := TRUE;
2400:
2401: CURSOR C1 IS
2402: SELECT 'x'
2403: FROM csi_i_parties
2404: WHERE instance_id = p_Instance_id
2405: -- AND relationship_type_code = p_relationship_type
2406: AND preferred_flag = 'Y'
2407: AND contact_flag = 'Y'

Line 2452: FROM csi_i_parties

2448: l_return_value BOOLEAN := TRUE;
2449:
2450: CURSOR C1 IS
2451: SELECT 'x'
2452: FROM csi_i_parties
2453: WHERE instance_id = p_Instance_id
2454: AND relationship_type_code = p_relationship_type
2455: AND primary_flag = 'Y'
2456: AND contact_flag = 'Y'

Line 2501: FROM csi_i_parties

2497: l_return_value BOOLEAN := TRUE;
2498:
2499: CURSOR C1 IS
2500: SELECT 'x'
2501: FROM csi_i_parties
2502: WHERE instance_id = p_Instance_id
2503: -- AND relationship_type_code = p_relationship_type
2504: AND preferred_flag = 'Y'
2505: AND contact_flag <> 'Y'

Line 2551: FROM csi_i_parties

2547: l_return_value BOOLEAN := TRUE;
2548:
2549: CURSOR C1 IS
2550: SELECT 'x'
2551: FROM csi_i_parties
2552: WHERE instance_id = p_Instance_id
2553: AND relationship_type_code = p_relationship_type
2554: AND primary_flag = 'Y'
2555: AND contact_flag <> 'Y'