APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_SCA_INSERT_TBL_TYPE

Line 61: g_sca_insert_tbl_type cn_sca_insert_tbl_type;

57:
58: g_unloaded_txn_tbl g_rowid_tbl_type;
59: g_loaded_txn_rowid_tbl g_rowid_tbl_type;
60: g_loaded_txn_comid_tbl g_comm_lines_api_id_tbl_type;
61: g_sca_insert_tbl_type cn_sca_insert_tbl_type;
62:
63: --
64: PROCEDURE debugmsg(msg VARCHAR2) IS
65: BEGIN

Line 1158: -- g_sca_insert_tbl_type := cn_sca_insert_tbl_type(cn_sca_insert_rec_type(1,1,1,1,1,1,1,1,1));

1154: IF (l_no_of_records > 0) THEN
1155: /* insert the credited transactions into api table */
1156: /* process all the rows even if some of them fail */
1157:
1158: -- g_sca_insert_tbl_type := cn_sca_insert_tbl_type(cn_sca_insert_rec_type(1,1,1,1,1,1,1,1,1));
1159: -- FOR i IN p_trans_object_id_tbl.FIRST .. p_trans_object_id_tbl.LAST
1160: -- LOOP
1161: -- g_sca_insert_tbl_type.EXTEND;
1162: -- g_sca_insert_tbl_type(i) := cn_sca_insert_rec_type(p_trans_object_id_tbl(i)

Line 1537: -- as cn_sca_insert_tbl_type)) parent

1533: AND ccla.org_id = p_org_id
1534: AND p_del_flag_tbl(i) <> 'Y';
1535:
1536: --, table ( cast ( cn_sca_credits_batch_pub.convert_to_table()
1537: -- as cn_sca_insert_tbl_type)) parent
1538: -- WHERE ccla.comm_lines_api_id = parent.trans_object_id
1539: -- AND ccla.org_id = p_org_id
1540: -- AND parent.del_flag <> 'Y';
1541:

Line 3559: RETURN cn_sca_insert_tbl_type IS

3555: errbuf := 'Unexpected Error : ' || SQLERRM;
3556: END batch_process_winners;
3557:
3558: FUNCTION convert_to_table
3559: RETURN cn_sca_insert_tbl_type IS
3560:
3561: BEGIN
3562:
3563: RETURN g_sca_insert_tbl_type;