APPS.FUN_TRX_PVT dependencies on FUN_DIST_LINES

Line 2590: INSERT INTO fun_dist_lines(DIST_ID,

2586: WHERE headers.batch_id = l_reversed_batch_id
2587: AND headers.original_trx_id = lines.trx_id;
2588:
2589: -- Insert into dist_lines
2590: INSERT INTO fun_dist_lines(DIST_ID,
2591: LINE_ID,
2592: DIST_NUMBER,
2593: PARTY_ID,
2594: PARTY_TYPE_FLAG,

Line 2624: SELECT fun_dist_lines_s.nextval,

2620: LAST_UPDATED_BY,
2621: LAST_UPDATE_DATE,
2622: LAST_UPDATE_LOGIN,
2623: trx_id)
2624: SELECT fun_dist_lines_s.nextval,
2625: reversed_lines.LINE_ID,
2626: orig_dists.DIST_NUMBER,
2627: orig_dists.PARTY_ID,
2628: orig_dists.PARTY_TYPE_FLAG,

Line 2664: fun_dist_lines orig_dists

2660: FROM fun_trx_headers reversed_hdrs,
2661: fun_trx_lines reversed_lines,
2662: --fun_batch_dists reversed_b_dists,
2663: fun_trx_lines orig_lines,
2664: fun_dist_lines orig_dists
2665: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
2666: AND reversed_hdrs.trx_id = reversed_lines.trx_id
2667: AND reversed_hdrs.original_trx_id = orig_lines.trx_id
2668: AND orig_lines.line_id = orig_dists.line_id

Line 3041: INSERT INTO fun_dist_lines(DIST_ID,

3037: WHERE headers.batch_id = l_reversed_batch_id
3038: AND headers.original_trx_id = lines.trx_id;
3039:
3040: -- Insert into dist_lines
3041: INSERT INTO fun_dist_lines(DIST_ID,
3042: LINE_ID,
3043: DIST_NUMBER,
3044: PARTY_ID,
3045: PARTY_TYPE_FLAG,

Line 3075: SELECT fun_dist_lines_s.nextval,

3071: LAST_UPDATED_BY,
3072: LAST_UPDATE_DATE,
3073: LAST_UPDATE_LOGIN,
3074: trx_id)
3075: SELECT fun_dist_lines_s.nextval,
3076: reversed_lines.LINE_ID,
3077: orig_dists.DIST_NUMBER,
3078: orig_dists.PARTY_ID,
3079: orig_dists.PARTY_TYPE_FLAG,

Line 3115: fun_dist_lines orig_dists

3111: FROM fun_trx_headers reversed_hdrs,
3112: fun_trx_lines reversed_lines,
3113: --fun_batch_dists reversed_b_dists,
3114: fun_trx_lines orig_lines,
3115: fun_dist_lines orig_dists
3116: WHERE reversed_hdrs.batch_id = l_reversed_batch_id
3117: AND reversed_hdrs.trx_id = reversed_lines.trx_id
3118: AND reversed_hdrs.original_trx_id = orig_lines.trx_id
3119: AND orig_lines.line_id = orig_dists.line_id

Line 3986: fun_dist_lines dists

3982: dists.ccid,
3983: hdrs.trx_number
3984: FROM fun_trx_headers hdrs,
3985: fun_trx_lines lines,
3986: fun_dist_lines dists
3987: WHERE hdrs.batch_id = p_batch_id
3988: AND hdrs.trx_id = lines.trx_id
3989: AND lines.line_id = dists.line_id
3990: AND dists.party_type_flag = 'I'

Line 4085: DELETE FROM fun_dist_lines

4081:
4082: -- Delete the distributions generated for the initiator
4083: IF p_trx_tbl.COUNT > 0 THEN
4084: FOR i IN p_trx_tbl.first..p_trx_tbl.last LOOP
4085: DELETE FROM fun_dist_lines
4086: WHERE party_type_flag = 'I'
4087: AND dist_type_flag = 'L'
4088: --AND auto_generate_flag = 'Y'
4089: AND line_id IN

Line 4127: INSERT INTO fun_dist_lines(DIST_ID,

4123: LOOP
4124: l_amount_cr := ROUND(((p_init_dist_tbl(i).amount_cr * p_trx_tbl(t).init_amount_dr)/l_total)/ l_mau ) * l_mau;
4125: l_amount_dr := ROUND(((p_init_dist_tbl(i).amount_dr * p_trx_tbl(t).init_amount_cr)/l_total)/ l_mau ) * l_mau;
4126:
4127: INSERT INTO fun_dist_lines(DIST_ID,
4128: LINE_ID,
4129: DIST_NUMBER,
4130: PARTY_ID,
4131: PARTY_TYPE_FLAG,

Line 4145: VALUES (fun_dist_lines_s.nextval,

4141: LAST_UPDATED_BY,
4142: LAST_UPDATE_DATE,
4143: LAST_UPDATE_LOGIN,
4144: trx_id)
4145: VALUES (fun_dist_lines_s.nextval,
4146: l_line_id,
4147: i,
4148: p_trx_tbl(t).initiator_id,
4149: 'I',