APPS.FUN_PERIOD_STATUS_PKG dependencies on FUN_TRX_LINES

Line 608: l_line_id FUN_TRX_LINES.LINE_ID%TYPE;

604: l_batch_number FUN_TRX_BATCHES.BATCH_NUMBER%TYPE;
605: l_running_total_dr FUN_TRX_BATCHES.RUNNING_TOTAL_DR%TYPE;
606: l_running_total_cr FUN_TRX_BATCHES.RUNNING_TOTAL_CR%TYPE;
607: l_header_trx_id FUN_TRX_HEADERS.TRX_ID%TYPE;
608: l_line_id FUN_TRX_LINES.LINE_ID%TYPE;
609: l_start_date FUN_PERIOD_STATUSES.START_DATE%TYPE;
610: l_end_date FUN_PERIOD_STATUSES.END_DATE%TYPE;
611: sqlstmt VARCHAR2(3000);
612:

Line 823: SELECT FUN_TRX_LINES_S.nextval INTO l_line_id FROM DUAL;

819: LOOP
820: l_header_trx_id := 0;
821: l_line_id := 0;
822: SELECT FUN_TRX_HEADERS_S.nextval INTO l_header_trx_id FROM DUAL;
823: SELECT FUN_TRX_LINES_S.nextval INTO l_line_id FROM DUAL;
824:
825: INSERT INTO FUN_TRX_HEADERS
826: (TRX_ID,
827: BATCH_ID,

Line 921: INSERT INTO FUN_TRX_LINES

917: ATTRIBUTE_CATEGORY
918: FROM FUN_TRX_HEADERS
919: WHERE TRX_ID = l_trx_id.TRX_ID;
920:
921: INSERT INTO FUN_TRX_LINES
922: (LINE_ID,
923: TRX_ID,
924: CREATED_BY,
925: CREATION_DATE,

Line 950: FROM FUN_TRX_LINES

946: INIT_AMOUNT_DR,
947: RECI_AMOUNT_CR,
948: RECI_AMOUNT_DR,
949: DESCRIPTION
950: FROM FUN_TRX_LINES
951: WHERE TRX_ID = l_trx_id.TRX_ID;
952:
953: INSERT INTO FUN_DIST_LINES
954: (TRX_ID,