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_PARTY_RELATIONSHIPS_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 20: x_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_header_rec,

16: /*----------------------------------------------------------*/
17:
18: PROCEDURE Initialize_acct_rec_no_dump
19: (
20: x_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_header_rec,
21: p_ip_account_id IN NUMBER ,
22: x_first_no_dump IN OUT NOCOPY DATE
23: ) IS
24:

Line 96: x_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_header_rec,

92: /*----------------------------------------------------------*/
93:
94: PROCEDURE Initialize_acct_rec
95: (
96: x_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_header_rec,
97: p_ip_account_hist_id IN NUMBER ,
98: x_nearest_full_dump IN OUT NOCOPY DATE
99: ) IS
100:

Line 167: x_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_header_tbl,

163: /*----------------------------------------------------------*/
164:
165: PROCEDURE Construct_acct_from_hist
166: (
167: x_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_header_tbl,
168: p_time_stamp IN DATE
169: ) IS
170:
171: l_nearest_full_dump DATE := sysdate;

Line 173: l_party_account_tbl csi_datastructures_pub.party_account_header_tbl;

169: ) IS
170:
171: l_nearest_full_dump DATE := sysdate;
172: l_ip_account_hist_id NUMBER;
173: l_party_account_tbl csi_datastructures_pub.party_account_header_tbl;
174: l_acct_count NUMBER := 0;
175: --
176: Process_next EXCEPTION;
177:

Line 442: (p_account_header_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_header_tbl)

438: /* id columns */
439: /*----------------------------------------------------------*/
440:
441: PROCEDURE Resolve_id_columns
442: (p_account_header_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_header_tbl)
443:
444: IS
445:
446: BEGIN

Line 564: x_pty_acct_query_rec OUT NOCOPY csi_datastructures_pub.party_account_header_rec

560:
561: PROCEDURE Get_acct_Column_Values
562: (
563: p_get_acct_cursor_id IN NUMBER ,
564: x_pty_acct_query_rec OUT NOCOPY csi_datastructures_pub.party_account_header_rec
565: ) IS
566:
567: BEGIN
568:

Line 607: l_party_acct_rec csi_datastructures_pub.party_account_header_rec;

603: PROCEDURE Define_Acct_Columns
604: (
605: p_get_acct_cursor_id IN NUMBER
606: ) IS
607: l_party_acct_rec csi_datastructures_pub.party_account_header_rec;
608: BEGIN
609:
610: dbms_sql.define_column(p_get_acct_cursor_id, 1, l_party_acct_rec.ip_account_id);
611: dbms_sql.define_column(p_get_acct_cursor_id, 2, l_party_acct_rec.instance_party_id);

Line 647: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,

643: /*----------------------------------------------------------*/
644:
645: PROCEDURE Bind_Acct_variable
646: (
647: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
648: p_get_acct_cursor_id IN NUMBER
649: ) IS
650:
651: BEGIN

Line 683: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec

679: /*----------------------------------------------------------*/
680:
681: PROCEDURE Gen_Acct_Where_Clause
682: (
683: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec
684: ,x_where_clause OUT NOCOPY VARCHAR2
685: ) IS
686:
687: BEGIN

Line 756: x_party_rec IN OUT NOCOPY csi_datastructures_pub.party_header_rec,

752: /*----------------------------------------------------------*/
753:
754: PROCEDURE Initialize_pty_rec_no_dump
755: (
756: x_party_rec IN OUT NOCOPY csi_datastructures_pub.party_header_rec,
757: p_inst_party_id IN NUMBER,
758: x_first_no_dump IN OUT NOCOPY DATE
759: ) IS
760:

Line 842: x_party_rec IN OUT NOCOPY csi_datastructures_pub.party_header_rec,

838: /*----------------------------------------------------------*/
839:
840: PROCEDURE Initialize_pty_rec
841: (
842: x_party_rec IN OUT NOCOPY csi_datastructures_pub.party_header_rec,
843: p_inst_party_hist_id IN NUMBER,
844: x_nearest_full_dump IN OUT NOCOPY DATE
845: ) IS
846:

Line 922: x_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_header_tbl,

918: /*----------------------------------------------------------*/
919:
920: PROCEDURE Construct_pty_from_hist
921: (
922: x_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_header_tbl,
923: p_time_stamp IN DATE
924: ) IS
925:
926: l_nearest_full_dump DATE := sysdate;

Line 928: l_party_tbl csi_datastructures_pub.party_header_tbl;

924: ) IS
925:
926: l_nearest_full_dump DATE := sysdate;
927: l_inst_party_hist_id NUMBER;
928: l_party_tbl csi_datastructures_pub.party_header_tbl;
929: l_pty_count NUMBER := 0;
930: --
931: Process_next EXCEPTION;
932:

Line 1225: x_party_rec OUT NOCOPY csi_datastructures_pub.party_header_rec

1221:
1222: PROCEDURE Get_Pty_Column_Values
1223: (
1224: p_get_pty_cursor_id IN NUMBER ,
1225: x_party_rec OUT NOCOPY csi_datastructures_pub.party_header_rec
1226: ) IS
1227:
1228: BEGIN
1229:

Line 1271: l_party_rec csi_datastructures_pub.party_header_rec;

1267: PROCEDURE Define_Pty_Columns
1268: (
1269: p_get_pty_cursor_id IN NUMBER
1270: ) IS
1271: l_party_rec csi_datastructures_pub.party_header_rec;
1272: BEGIN
1273:
1274: dbms_sql.define_column(p_get_pty_cursor_id, 1, l_party_rec.instance_party_id);
1275: dbms_sql.define_column(p_get_pty_cursor_id, 2, l_party_rec.instance_id);

Line 1314: p_party_query_rec IN csi_datastructures_pub.party_query_rec,

1310: /*----------------------------------------------------------*/
1311:
1312: PROCEDURE Bind_Pty_variable
1313: (
1314: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
1315: p_cur_get_pty_rel IN NUMBER
1316: ) IS
1317:
1318: BEGIN

Line 1350: p_party_query_rec IN csi_datastructures_pub.party_query_rec

1346: /*----------------------------------------------------------*/
1347:
1348: PROCEDURE Gen_Pty_Where_Clause
1349: (
1350: p_party_query_rec IN csi_datastructures_pub.party_query_rec
1351: ,x_where_clause OUT NOCOPY VARCHAR2
1352: ) IS
1353:
1354: BEGIN

Line 1427: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec

1423: ( p_api_version IN NUMBER
1424: ,p_commit IN VARCHAR2
1425: ,p_init_msg_list IN VARCHAR2
1426: ,p_validation_level IN NUMBER
1427: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec
1428: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1429: ,x_return_status OUT NOCOPY VARCHAR2
1430: ,x_msg_count OUT NOCOPY NUMBER
1431: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1428: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

1424: ,p_commit IN VARCHAR2
1425: ,p_init_msg_list IN VARCHAR2
1426: ,p_validation_level IN NUMBER
1427: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec
1428: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1429: ,x_return_status OUT NOCOPY VARCHAR2
1430: ,x_msg_count OUT NOCOPY NUMBER
1431: ,x_msg_data OUT NOCOPY VARCHAR2
1432: ,p_party_source_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_source_tbl

Line 1444: l_party_rec csi_datastructures_pub.party_rec;

1440:
1441: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INST_PARTY_RELATIONSHIP';
1442: l_api_version CONSTANT NUMBER := 1.0;
1443: l_csi_debug_level NUMBER;
1444: l_party_rec csi_datastructures_pub.party_rec;
1445: l_msg_index NUMBER;
1446: l_msg_count NUMBER;
1447: l_process_flag BOOLEAN := TRUE;
1448: l_inst_party_his_id NUMBER;

Line 2248: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec

2244: ( p_api_version IN NUMBER
2245: ,p_commit IN VARCHAR2
2246: ,p_init_msg_list IN VARCHAR2
2247: ,p_validation_level IN NUMBER
2248: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec
2249: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2250: ,x_return_status OUT NOCOPY VARCHAR2
2251: ,x_msg_count OUT NOCOPY NUMBER
2252: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2249: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

2245: ,p_commit IN VARCHAR2
2246: ,p_init_msg_list IN VARCHAR2
2247: ,p_validation_level IN NUMBER
2248: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec
2249: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2250: ,x_return_status OUT NOCOPY VARCHAR2
2251: ,x_msg_count OUT NOCOPY NUMBER
2252: ,x_msg_data OUT NOCOPY VARCHAR2
2253: ) IS

Line 2258: l_curr_party_rec csi_datastructures_pub.party_rec;

2254:
2255: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INST_PARTY_RELATIONSHIP';
2256: l_api_version CONSTANT NUMBER := 1.0;
2257: l_csi_debug_level NUMBER;
2258: l_curr_party_rec csi_datastructures_pub.party_rec;
2259: l_temp_party_rec csi_datastructures_pub.party_rec;
2260: l_cont_party_rec csi_datastructures_pub.party_rec;
2261: l_init_party_rec csi_datastructures_pub.party_rec;
2262: l_msg_index NUMBER;

Line 2259: l_temp_party_rec csi_datastructures_pub.party_rec;

2255: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INST_PARTY_RELATIONSHIP';
2256: l_api_version CONSTANT NUMBER := 1.0;
2257: l_csi_debug_level NUMBER;
2258: l_curr_party_rec csi_datastructures_pub.party_rec;
2259: l_temp_party_rec csi_datastructures_pub.party_rec;
2260: l_cont_party_rec csi_datastructures_pub.party_rec;
2261: l_init_party_rec csi_datastructures_pub.party_rec;
2262: l_msg_index NUMBER;
2263: l_msg_count NUMBER;

Line 2260: l_cont_party_rec csi_datastructures_pub.party_rec;

2256: l_api_version CONSTANT NUMBER := 1.0;
2257: l_csi_debug_level NUMBER;
2258: l_curr_party_rec csi_datastructures_pub.party_rec;
2259: l_temp_party_rec csi_datastructures_pub.party_rec;
2260: l_cont_party_rec csi_datastructures_pub.party_rec;
2261: l_init_party_rec csi_datastructures_pub.party_rec;
2262: l_msg_index NUMBER;
2263: l_msg_count NUMBER;
2264: l_line_count NUMBER;

Line 2261: l_init_party_rec csi_datastructures_pub.party_rec;

2257: l_csi_debug_level NUMBER;
2258: l_curr_party_rec csi_datastructures_pub.party_rec;
2259: l_temp_party_rec csi_datastructures_pub.party_rec;
2260: l_cont_party_rec csi_datastructures_pub.party_rec;
2261: l_init_party_rec csi_datastructures_pub.party_rec;
2262: l_msg_index NUMBER;
2263: l_msg_count NUMBER;
2264: l_line_count NUMBER;
2265: l_object_version_number NUMBER;

Line 2269: l_party_account_rec csi_datastructures_pub.party_account_rec;

2265: l_object_version_number NUMBER;
2266: l_inst_party_his_id NUMBER;
2267: l_full_dump_frequency NUMBER;
2268: l_mod_value NUMBER;
2269: l_party_account_rec csi_datastructures_pub.party_account_rec;
2270: l_internal_party_id NUMBER;
2271:
2272: x_msg_index_out NUMBER;
2273: l_acct_class_code VARCHAR2(10);

Line 2493: l_curr_instance_rec csi_datastructures_pub.instance_rec;

2489: NULL REC_INDEX
2490: FROM csi_item_instances
2491: WHERE instance_id = p_instance_id;
2492:
2493: l_curr_instance_rec csi_datastructures_pub.instance_rec;
2494:
2495:
2496: CURSOR pty_hist_csr (p_party_hist_id NUMBER) IS
2497: SELECT instance_party_history_id

Line 2558: l_party_hist_rec csi_datastructures_pub.party_history_rec;

2554: FOR UPDATE OF object_version_number ;
2555: l_pty_hist_csr pty_hist_csr%rowtype;
2556: l_party_hist_id NUMBER;
2557: l_open_service VARCHAR2(1);
2558: l_party_hist_rec csi_datastructures_pub.party_history_rec;
2559: l_ins_pty_found NUMBER;
2560: l_pty_end_date DATE;
2561:
2562: l_inst_just_expired VARCHAR2(1) := FND_API.G_FALSE; --Added for bug 7517240

Line 2938: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

2934: END IF;
2935: END IF;
2936: END IF;
2937: -- Grab the internal party id from csi_installed paramters
2938: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2939: csi_gen_utility_pvt.populate_install_param_rec;
2940: END IF;
2941: --
2942: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 2942: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

2938: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
2939: csi_gen_utility_pvt.populate_install_param_rec;
2940: END IF;
2941: --
2942: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2943: --
2944: IF l_internal_party_id IS NULL THEN
2945: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
2946: FND_MSG_PUB.ADD;

Line 3189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

3185: RAISE FND_API.G_EXC_ERROR;
3186: END IF;
3187:
3188: -- Get the full_dump_frequency from csi_install_parameter
3189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3190: csi_gen_utility_pvt.populate_install_param_rec;
3191: END IF;
3192: --
3193: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;

Line 3193: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;

3189: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3190: csi_gen_utility_pvt.populate_install_param_rec;
3191: END IF;
3192: --
3193: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3194: --
3195: IF l_full_dump_frequency IS NULL THEN
3196: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
3197: FND_MSG_PUB.ADD;

Line 4303: ,p_instance_party_rec IN csi_datastructures_pub.party_rec

4299: ( p_api_version IN NUMBER
4300: ,p_commit IN VARCHAR2
4301: ,p_init_msg_list IN VARCHAR2
4302: ,p_validation_level IN NUMBER
4303: ,p_instance_party_rec IN csi_datastructures_pub.party_rec
4304: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4305: ,x_return_status OUT NOCOPY VARCHAR2
4306: ,x_msg_count OUT NOCOPY NUMBER
4307: ,x_msg_data OUT NOCOPY VARCHAR2

Line 4304: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

4300: ,p_commit IN VARCHAR2
4301: ,p_init_msg_list IN VARCHAR2
4302: ,p_validation_level IN NUMBER
4303: ,p_instance_party_rec IN csi_datastructures_pub.party_rec
4304: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4305: ,x_return_status OUT NOCOPY VARCHAR2
4306: ,x_msg_count OUT NOCOPY NUMBER
4307: ,x_msg_data OUT NOCOPY VARCHAR2
4308: ) IS

Line 4313: l_party_rec csi_datastructures_pub.party_rec;

4309:
4310: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_INST_PARTY_RELATIONSHIP';
4311: l_api_version CONSTANT NUMBER := 1.0;
4312: l_csi_debug_level NUMBER;
4313: l_party_rec csi_datastructures_pub.party_rec;
4314: l_msg_index NUMBER;
4315: l_msg_count NUMBER;
4316: l_line_count NUMBER;
4317: l_full_dump_frequency NUMBER;

Line 4319: l_curr_party_rec csi_datastructures_pub.party_rec;

4315: l_msg_count NUMBER;
4316: l_line_count NUMBER;
4317: l_full_dump_frequency NUMBER;
4318: l_mod_value NUMBER;
4319: l_curr_party_rec csi_datastructures_pub.party_rec;
4320: l_party_account_rec csi_datastructures_pub.party_account_rec;
4321: l_OBJECT_VERSION_NUMBER NUMBER;
4322: l_inst_party_his_id NUMBER;
4323: l_temp_party_acct_rec csi_datastructures_pub.party_account_rec;

Line 4320: l_party_account_rec csi_datastructures_pub.party_account_rec;

4316: l_line_count NUMBER;
4317: l_full_dump_frequency NUMBER;
4318: l_mod_value NUMBER;
4319: l_curr_party_rec csi_datastructures_pub.party_rec;
4320: l_party_account_rec csi_datastructures_pub.party_account_rec;
4321: l_OBJECT_VERSION_NUMBER NUMBER;
4322: l_inst_party_his_id NUMBER;
4323: l_temp_party_acct_rec csi_datastructures_pub.party_account_rec;
4324: --

Line 4323: l_temp_party_acct_rec csi_datastructures_pub.party_account_rec;

4319: l_curr_party_rec csi_datastructures_pub.party_rec;
4320: l_party_account_rec csi_datastructures_pub.party_account_rec;
4321: l_OBJECT_VERSION_NUMBER NUMBER;
4322: l_inst_party_his_id NUMBER;
4323: l_temp_party_acct_rec csi_datastructures_pub.party_account_rec;
4324: --
4325: CURSOR get_curr_party_rec (p_inst_party_id IN NUMBER) IS
4326: SELECT
4327: instance_party_id ,

Line 4551: ,p_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_rec

4547: ( p_api_version IN NUMBER
4548: ,p_commit IN VARCHAR2
4549: ,p_init_msg_list IN VARCHAR2
4550: ,p_validation_level IN NUMBER
4551: ,p_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_rec
4552: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4553: ,x_return_status OUT NOCOPY VARCHAR2
4554: ,x_msg_count OUT NOCOPY NUMBER
4555: ,x_msg_data OUT NOCOPY VARCHAR2

Line 4552: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

4548: ,p_commit IN VARCHAR2
4549: ,p_init_msg_list IN VARCHAR2
4550: ,p_validation_level IN NUMBER
4551: ,p_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_rec
4552: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
4553: ,x_return_status OUT NOCOPY VARCHAR2
4554: ,x_msg_count OUT NOCOPY NUMBER
4555: ,x_msg_data OUT NOCOPY VARCHAR2
4556: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl

Line 4567: l_party_account_rec csi_datastructures_pub.party_account_rec;

4563:
4564: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INST_PARTY_ACCOUNT';
4565: l_api_version CONSTANT NUMBER := 1.0;
4566: l_csi_debug_level NUMBER;
4567: l_party_account_rec csi_datastructures_pub.party_account_rec;
4568: l_party_rec csi_datastructures_pub.party_rec;
4569: l_msg_index NUMBER;
4570: l_msg_count NUMBER;
4571: l_process_flag BOOLEAN := TRUE;

Line 4568: l_party_rec csi_datastructures_pub.party_rec;

4564: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INST_PARTY_ACCOUNT';
4565: l_api_version CONSTANT NUMBER := 1.0;
4566: l_csi_debug_level NUMBER;
4567: l_party_account_rec csi_datastructures_pub.party_account_rec;
4568: l_party_rec csi_datastructures_pub.party_rec;
4569: l_msg_index NUMBER;
4570: l_msg_count NUMBER;
4571: l_process_flag BOOLEAN := TRUE;
4572: l_ip_account_history_id NUMBER;

Line 5319: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec

5315: ( p_api_version IN NUMBER
5316: ,p_commit IN VARCHAR2
5317: ,p_init_msg_list IN VARCHAR2
5318: ,p_validation_level IN NUMBER
5319: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec
5320: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5321: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
5322: ,x_return_status OUT NOCOPY VARCHAR2
5323: ,x_msg_count OUT NOCOPY NUMBER

Line 5320: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

5316: ,p_commit IN VARCHAR2
5317: ,p_init_msg_list IN VARCHAR2
5318: ,p_validation_level IN NUMBER
5319: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec
5320: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5321: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
5322: ,x_return_status OUT NOCOPY VARCHAR2
5323: ,x_msg_count OUT NOCOPY NUMBER
5324: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5330: -- l_curr_party_acct_rec csi_datastructures_pub.party_account_rec;

5326:
5327: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INST_PARTY_ACCOUNT';
5328: l_api_version CONSTANT NUMBER := 1.0;
5329: l_csi_debug_level NUMBER;
5330: -- l_curr_party_acct_rec csi_datastructures_pub.party_account_rec;
5331: l_temp_party_account_rec csi_datastructures_pub.party_account_rec;
5332: l_party_rec csi_datastructures_pub.party_rec;
5333: l_msg_index NUMBER;
5334: l_msg_count NUMBER;

Line 5331: l_temp_party_account_rec csi_datastructures_pub.party_account_rec;

5327: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INST_PARTY_ACCOUNT';
5328: l_api_version CONSTANT NUMBER := 1.0;
5329: l_csi_debug_level NUMBER;
5330: -- l_curr_party_acct_rec csi_datastructures_pub.party_account_rec;
5331: l_temp_party_account_rec csi_datastructures_pub.party_account_rec;
5332: l_party_rec csi_datastructures_pub.party_rec;
5333: l_msg_index NUMBER;
5334: l_msg_count NUMBER;
5335: l_mod_value NUMBER;

Line 5332: l_party_rec csi_datastructures_pub.party_rec;

5328: l_api_version CONSTANT NUMBER := 1.0;
5329: l_csi_debug_level NUMBER;
5330: -- l_curr_party_acct_rec csi_datastructures_pub.party_account_rec;
5331: l_temp_party_account_rec csi_datastructures_pub.party_account_rec;
5332: l_party_rec csi_datastructures_pub.party_rec;
5333: l_msg_index NUMBER;
5334: l_msg_count NUMBER;
5335: l_mod_value NUMBER;
5336: l_object_version_number NUMBER;

Line 5458: l_account_hist_rec csi_datastructures_pub.account_history_rec;

5454: l_old_pty_acct_id NUMBER; -- Added by sguthiva for bug 2307804
5455: l_new_pty_acct_id NUMBER; -- Added by sguthiva for bug 2307804
5456: l_last_vld_org NUMBER; -- Added by sguthiva for bug 2307804
5457: l_party_account_id NUMBER; -- Added by sguthiva for bug 2307804
5458: l_account_hist_rec csi_datastructures_pub.account_history_rec;
5459: l_rel_type_code VARCHAR2(30);
5460: l_acct_end_date DATE;
5461: l_temp_acct_date DATE;
5462: l_found_for_update VARCHAR2(1):='N';

Line 5638: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

5634: IF ( p_party_account_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE) THEN
5635: IF ((l_curr_party_acct_rec.relationship_type_code = 'OWNER')
5636: AND (l_party_relation = 'OWNER')) THEN
5637: -- Added by sguthiva for bug 2307804
5638: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5639: csi_gen_utility_pvt.populate_install_param_rec;
5640: END IF;
5641: --
5642: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 5642: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

5638: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5639: csi_gen_utility_pvt.populate_install_param_rec;
5640: END IF;
5641: --
5642: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5643: --
5644: IF l_internal_party_id IS NULL THEN
5645: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5646: FND_MSG_PUB.ADD;

Line 5960: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

5956: -- Generate a unique instance_party_history_id from the sequence
5957: l_ip_account_history_id := CSI_Instance_parties_vld_pvt.gen_ip_account_hist_id;
5958:
5959: -- Get the full_dump_frequency from csi_install_parameter
5960: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5961: csi_gen_utility_pvt.populate_install_param_rec;
5962: END IF;
5963: --
5964: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;

Line 5964: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;

5960: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
5961: csi_gen_utility_pvt.populate_install_param_rec;
5962: END IF;
5963: --
5964: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
5965: --
5966: IF l_full_dump_frequency IS NULL THEN
5967: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
5968: FND_MSG_PUB.ADD;

Line 6917: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

6913: ELSE
6914: l_last_vld_org := p_party_account_rec.vld_organization_id;
6915: END IF;
6916: --
6917: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6918: csi_gen_utility_pvt.populate_install_param_rec;
6919: END IF;
6920: --
6921: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 6921: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

6917: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6918: csi_gen_utility_pvt.populate_install_param_rec;
6919: END IF;
6920: --
6921: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6922: --
6923: IF l_internal_party_id IS NULL THEN
6924: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
6925: FND_MSG_PUB.ADD;

Line 7176: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec

7172: ( p_api_version IN NUMBER
7173: ,p_commit IN VARCHAR2
7174: ,p_init_msg_list IN VARCHAR2
7175: ,p_validation_level IN NUMBER
7176: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec
7177: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7178: ,x_return_status OUT NOCOPY VARCHAR2
7179: ,x_msg_count OUT NOCOPY NUMBER
7180: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7177: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

7173: ,p_commit IN VARCHAR2
7174: ,p_init_msg_list IN VARCHAR2
7175: ,p_validation_level IN NUMBER
7176: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec
7177: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
7178: ,x_return_status OUT NOCOPY VARCHAR2
7179: ,x_msg_count OUT NOCOPY NUMBER
7180: ,x_msg_data OUT NOCOPY VARCHAR2
7181: ) IS

Line 7186: l_party_account_rec csi_datastructures_pub.party_account_rec;

7182:
7183: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_INST_PARTY_ACCOUNT';
7184: l_api_version CONSTANT NUMBER := 1.0;
7185: l_csi_debug_level NUMBER;
7186: l_party_account_rec csi_datastructures_pub.party_account_rec;
7187: -- l_curr_party_acct_rec csi_datastructures_pub.party_account_rec;
7188: l_msg_count NUMBER;
7189: l_msg_data VARCHAR2(100);
7190: l_txn_id NUMBER;

Line 7187: -- l_curr_party_acct_rec csi_datastructures_pub.party_account_rec;

7183: l_api_name CONSTANT VARCHAR2(30) := 'EXPIRE_INST_PARTY_ACCOUNT';
7184: l_api_version CONSTANT NUMBER := 1.0;
7185: l_csi_debug_level NUMBER;
7186: l_party_account_rec csi_datastructures_pub.party_account_rec;
7187: -- l_curr_party_acct_rec csi_datastructures_pub.party_account_rec;
7188: l_msg_count NUMBER;
7189: l_msg_data VARCHAR2(100);
7190: l_txn_id NUMBER;
7191: l_msg_index NUMBER;

Line 7434: ,x_contact_details OUT NOCOPY csi_datastructures_pub.contact_details_rec

7430: ,p_validation_level IN NUMBER
7431: ,p_contact_party_id IN NUMBER
7432: ,p_contact_flag IN VARCHAR2
7433: ,p_party_tbl IN VARCHAR2
7434: ,x_contact_details OUT NOCOPY csi_datastructures_pub.contact_details_rec
7435: ,x_return_status OUT NOCOPY VARCHAR2
7436: ,x_msg_count OUT NOCOPY NUMBER
7437: ,x_msg_data OUT NOCOPY VARCHAR2
7438: ) IS

Line 7856: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl

7852: ,p_commit IN VARCHAR2
7853: ,p_init_msg_list IN VARCHAR2
7854: ,p_validation_level IN NUMBER
7855: ,p_transaction_id IN NUMBER
7856: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl
7857: ,x_return_status OUT NOCOPY VARCHAR2
7858: ,x_msg_count OUT NOCOPY NUMBER
7859: ,x_msg_data OUT NOCOPY VARCHAR2
7860: ) IS

Line 7871: l_contact_details csi_datastructures_pub.contact_details_rec ;

7867: l_flag VARCHAR2(1) :='N' ;
7868: l_instance_party_id NUMBER ;
7869: l_old_contact_party_id NUMBER ;
7870: l_new_contact_party_id NUMBER ;
7871: l_contact_details csi_datastructures_pub.contact_details_rec ;
7872: i NUMBER :=1;
7873: l_old_party_source_tbl VARCHAR2(30);
7874: l_new_party_source_tbl VARCHAR2(30);
7875: l_old_contact_flag VARCHAR2(1);

Line 7946: l_party_query_rec csi_datastructures_pub.party_query_rec;

7942: AND ciph.instance_party_id = cip.instance_party_id; -- Added by sk on 08-APR for fixing bug
7943: -- 2304649 .
7944: -- Added for bug 2781480
7945: l_time_stamp DATE;
7946: l_party_query_rec csi_datastructures_pub.party_query_rec;
7947: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7948: -- End addition for bug 2781480
7949: BEGIN
7950: -- Standard Start of API savepoint

Line 7947: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

7943: -- 2304649 .
7944: -- Added for bug 2781480
7945: l_time_stamp DATE;
7946: l_party_query_rec csi_datastructures_pub.party_query_rec;
7947: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
7948: -- End addition for bug 2781480
7949: BEGIN
7950: -- Standard Start of API savepoint
7951: -- SAVEPOINT get_inst_party_rel_hist;

Line 8592: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl

8588: ,p_commit IN VARCHAR2
8589: ,p_init_msg_list IN VARCHAR2
8590: ,p_validation_level IN NUMBER
8591: ,p_transaction_id IN NUMBER
8592: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
8593: ,x_return_status OUT NOCOPY VARCHAR2
8594: ,x_msg_count OUT NOCOPY NUMBER
8595: ,x_msg_data OUT NOCOPY VARCHAR2
8596: )IS

Line 8605: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;

8601: x_msg_index_out NUMBER ;
8602: l_count NUMBER := 0 ;
8603: l_flag VARCHAR2(1) :='N' ;
8604: i NUMBER :=1 ;
8605: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
8606: l_time_stamp DATE;
8607: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
8608: CURSOR get_account_hist(i_transaction_id NUMBER)
8609: IS

Line 8607: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;

8603: l_flag VARCHAR2(1) :='N' ;
8604: i NUMBER :=1 ;
8605: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
8606: l_time_stamp DATE;
8607: l_party_account_query_rec csi_datastructures_pub.party_account_query_rec;
8608: CURSOR get_account_hist(i_transaction_id NUMBER)
8609: IS
8610: SELECT cah.IP_ACCOUNT_HISTORY_ID ,
8611: cah.IP_ACCOUNT_ID ,