APPS.BIL_TX_UTIL_RPT_PKG dependencies on BIL_TX_PROD_TMP

Line 1097: EXECUTE IMMEDIATE 'TRUNCATE TABLE'||' '||l_schema||'.'||'BIL_TX_PROD_TMP ';

1093: l_status := p_param(i).parameter_id;
1094: END IF;
1095: END LOOP;
1096:
1097: EXECUTE IMMEDIATE 'TRUNCATE TABLE'||' '||l_schema||'.'||'BIL_TX_PROD_TMP ';
1098:
1099: IF (l_status IS NOT NULL) AND (NVL(UPPER(l_status),'ALL') <> 'ALL') THEN
1100: l_status := REPLACE(l_status,'''',null);
1101:

Line 1103: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (l_status);

1099: IF (l_status IS NOT NULL) AND (NVL(UPPER(l_status),'ALL') <> 'ALL') THEN
1100: l_status := REPLACE(l_status,'''',null);
1101:
1102: IF INSTR(l_status,',') = 0 THEN
1103: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (l_status);
1104: ELSE
1105: WHILE (INSTR(l_status,',') > 0) LOOP
1106: single_status := SUBSTR(l_status,1, INSTR(l_status,',') -1);
1107: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (single_status);

Line 1107: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (single_status);

1103: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (l_status);
1104: ELSE
1105: WHILE (INSTR(l_status,',') > 0) LOOP
1106: single_status := SUBSTR(l_status,1, INSTR(l_status,',') -1);
1107: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (single_status);
1108: l_status := SUBSTR(l_status,INSTR(l_status,',')+1 );
1109: END LOOP;
1110: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (l_status);
1111: END IF;

Line 1110: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (l_status);

1106: single_status := SUBSTR(l_status,1, INSTR(l_status,',') -1);
1107: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (single_status);
1108: l_status := SUBSTR(l_status,INSTR(l_status,',')+1 );
1109: END LOOP;
1110: INSERT INTO BIL_TX_PROD_TMP(ATTR4) VALUES (l_status);
1111: END IF;
1112:
1113:
1114:

Line 1116: FROM as_statuses_b asb, as_statuses_tl ast, BIL_TX_PROD_TMP B

1112:
1113:
1114:
1115: OPEN l_status_c FOR 'SELECT ast.meaning
1116: FROM as_statuses_b asb, as_statuses_tl ast, BIL_TX_PROD_TMP B
1117: WHERE asb.status_code = B.ATTR4
1118: AND asb.status_code = ast.status_code
1119: AND ast.language= userenv(''LANG'')
1120: AND asb.enabled_flag = ''Y''