APPS.CN_PROCESS_TAE_TRX_PUB dependencies on CN_COMM_LINES_API

Line 67: TYPE api_id_list is TABLE of cn_comm_lines_api.comm_lines_api_id%TYPE;

63: WIN.SOURCE_ID = -1001 AND
64: WIN.TRANS_OBJECT_TYPE_ID = -1002 AND
65: WIN.ORG_ID=p_org_id;
66:
67: TYPE api_id_list is TABLE of cn_comm_lines_api.comm_lines_api_id%TYPE;
68: TYPE org_id_list is TABLE of cn_comm_lines_api.org_id%TYPE;
69: TYPE role_list is TABLE of JTF_TAE_1001_SC_WINNERS.role%TYPE;
70: TYPE resource_id_list is TABLE of JTF_TAE_1001_SC_WINNERS.resource_id%TYPE;
71:

Line 68: TYPE org_id_list is TABLE of cn_comm_lines_api.org_id%TYPE;

64: WIN.TRANS_OBJECT_TYPE_ID = -1002 AND
65: WIN.ORG_ID=p_org_id;
66:
67: TYPE api_id_list is TABLE of cn_comm_lines_api.comm_lines_api_id%TYPE;
68: TYPE org_id_list is TABLE of cn_comm_lines_api.org_id%TYPE;
69: TYPE role_list is TABLE of JTF_TAE_1001_SC_WINNERS.role%TYPE;
70: TYPE resource_id_list is TABLE of JTF_TAE_1001_SC_WINNERS.resource_id%TYPE;
71:
72: l_api_id api_id_list;

Line 114: INSERT into CN_COMM_LINES_API

110: l_exceptions := FALSE;
111:
112: --dbms_output.put_line('Before Insert Statement');
113:
114: INSERT into CN_COMM_LINES_API
115: ( SALESREP_ID,
116: PROCESSED_DATE,
117: PROCESSED_PERIOD_ID,
118: TRANSACTION_AMOUNT,

Line 398: cn_comm_lines_api_s.NEXTVAL,

394: CCLA.ATTRIBUTE97,
395: CCLA.ATTRIBUTE98,
396: CCLA.ATTRIBUTE99,
397: CCLA.ATTRIBUTE100,
398: cn_comm_lines_api_s.NEXTVAL,
399: CCLA.CONC_BATCH_ID,
400: CCLA.PROCESS_BATCH_ID,
401: NULL,
402: CCLA.ROLLUP_DATE,

Line 488: FROM cn_comm_lines_api a,

484: CUME_DIST() OVER (PARTITION BY a.comm_lines_api_id
485: ORDER BY b.resource_id), 2) split_trx_amout,
486: ROW_NUMBER() OVER (PARTITION BY a.comm_lines_api_id
487: ORDER BY b.resource_id) rn
488: FROM cn_comm_lines_api a,
489: JTF_TAE_1001_SC_WINNERS b,
490: jtf_rs_roles_vl JR,
491: cn_salesreps CS
492: WHERE a.comm_lines_api_id = b.trans_object_id

Line 499: cn_comm_lines_api CCLA

495: AND JR.role_code = b.role
496: AND CS.resource_id = b.resource_id AND
497: a.org_id=p_org_id) result) ILV,
498: -- End of the ILV
499: cn_comm_lines_api CCLA
500: WHERE ILV.comm_lines_api_id = CCLA.comm_lines_api_id and
501: ILV.ORG_ID=CCLA.ORG_ID AND
502: CCLA.ORG_ID=p_org_id;
503:

Line 516: UPDATE cn_comm_lines_api api

512: IF l_api_id.count > 0 THEN
513:
514: FORALL j IN 1..l_api_id.COUNT
515:
516: UPDATE cn_comm_lines_api api
517: SET load_status = 'OBSOLETE',
518: adjust_status = 'FROZEN',
519: adjust_date = sysdate,
520: adjusted_by = l_adjusted_by,