eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEC_SUBSET_PVT dependencies on NUMBER_TBL_TYPE

Line 1920: -- P_FROM_SUBSET IN NUMBER_TBL_TYPE Required

1916: -- Parameters : P_SOURCE_ID IN NUMBER Required
1917: -- P_SERVER_ID IN NUMBER Required
1918: -- P_SCHED_ID IN NUMBER Required
1919: -- P_TARGET_GROUP_ID IN NUMBER Required
1920: -- P_FROM_SUBSET IN NUMBER_TBL_TYPE Required
1921: -- P_INTO_SUBSET IN NUMBER_TBL_TYPE Required
1922: -- P_ACTION_TYPE IN VARCHAR2 Required
1923: -- P_PHONE_SQL IN VARCHAR2 Required
1924: -- P_ENTRY_SQL IN VARCHAR2 Required

Line 1921: -- P_INTO_SUBSET IN NUMBER_TBL_TYPE Required

1917: -- P_SERVER_ID IN NUMBER Required
1918: -- P_SCHED_ID IN NUMBER Required
1919: -- P_TARGET_GROUP_ID IN NUMBER Required
1920: -- P_FROM_SUBSET IN NUMBER_TBL_TYPE Required
1921: -- P_INTO_SUBSET IN NUMBER_TBL_TYPE Required
1922: -- P_ACTION_TYPE IN VARCHAR2 Required
1923: -- P_PHONE_SQL IN VARCHAR2 Required
1924: -- P_ENTRY_SQL IN VARCHAR2 Required
1925: -- P_BATCH_SIZE IN NUMBER Required

Line 1952: l_return_tbl SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();

1948: IS
1949:
1950: TYPE SubsetEntryType IS REF CURSOR;
1951:
1952: l_return_tbl SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();
1953: l_locked_flag VARCHAR2(1);
1954: l_subset_entry_cursor SubsetEntryType;
1955: l_checked_entry_cursor SubsetEntryType;
1956: l_phone_cursor SubsetEntryType;

Line 2020: 'WHERE A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(:collection AS SYSTEM.NUMBER_TBL_TYPE))) ' ||

2016:
2017: BEGIN
2018: EXECUTE IMMEDIATE 'UPDATE IEC_G_RETURN_ENTRIES A ' ||
2019: 'SET A.PULLED_SUBSET_ID = :newSubsetId ' ||
2020: 'WHERE A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(:collection AS SYSTEM.NUMBER_TBL_TYPE))) ' ||
2021: 'AND A.RECORD_OUT_FLAG = ''N'' AND A.PULLED_SUBSET_ID IS NULL'
2022: USING P_INTO_SUBSET
2023: , l_return_tbl;
2024:

Line 2073: 'AND RETURNS_ID IN (SELECT * FROM TABLE(CAST(:collection AS SYSTEM.NUMBER_TBL_TYPE)))'

2069: ----------------------------------------------------------------
2070:
2071: OPEN l_checked_entry_cursor FOR 'SELECT RETURNS_ID FROM IEC_G_RETURN_ENTRIES ' ||
2072: 'WHERE PULLED_SUBSET_ID IS NULL ' ||
2073: 'AND RETURNS_ID IN (SELECT * FROM TABLE(CAST(:collection AS SYSTEM.NUMBER_TBL_TYPE)))'
2074: USING l_return_tbl;
2075:
2076: ----------------------------------------------------------------
2077: -- LOOP THRU ENTRIES RETRIEVED IN THE FETCH. These are the

Line 2399: -- P_FROM_SUBSETS IN NUMBER_TBL_TYPE

2395: -- Function :
2396: -- Parameters : P_SOURCE_ID IN NUMBER Required
2397: -- P_SERVER_ID IN NUMBER
2398: -- P_TARGET_GROUP_ID IN NUMBER
2399: -- P_FROM_SUBSETS IN NUMBER_TBL_TYPE
2400: -- P_INTO_SUBSETS IN NUMBER_TBL_TYPE
2401: -- P_ACTION_TYPE IN VARCHAR2
2402: -- X_NUM_PENDING OUT NUMBER
2403: -- X_ACTION_ID OUT NUMBER

Line 2400: -- P_INTO_SUBSETS IN NUMBER_TBL_TYPE

2396: -- Parameters : P_SOURCE_ID IN NUMBER Required
2397: -- P_SERVER_ID IN NUMBER
2398: -- P_TARGET_GROUP_ID IN NUMBER
2399: -- P_FROM_SUBSETS IN NUMBER_TBL_TYPE
2400: -- P_INTO_SUBSETS IN NUMBER_TBL_TYPE
2401: -- P_ACTION_TYPE IN VARCHAR2
2402: -- X_NUM_PENDING OUT NUMBER
2403: -- X_ACTION_ID OUT NUMBER
2404: --

Line 2416: , P_FROM_SUBSETS IN SYSTEM.NUMBER_TBL_TYPE

2412: , P_SERVER_ID IN NUMBER
2413: , P_CAMPAIGN_ID IN NUMBER
2414: , P_SCHEDULE_ID IN NUMBER
2415: , P_TARGET_GROUP_ID IN NUMBER
2416: , P_FROM_SUBSETS IN SYSTEM.NUMBER_TBL_TYPE
2417: , P_INTO_SUBSETS IN SYSTEM.NUMBER_TBL_TYPE
2418: , P_ACTION_TYPE IN VARCHAR2
2419: , X_NUM_PENDING OUT NOCOPY NUMBER
2420: , X_ACTION_ID OUT NOCOPY NUMBER

Line 2417: , P_INTO_SUBSETS IN SYSTEM.NUMBER_TBL_TYPE

2413: , P_CAMPAIGN_ID IN NUMBER
2414: , P_SCHEDULE_ID IN NUMBER
2415: , P_TARGET_GROUP_ID IN NUMBER
2416: , P_FROM_SUBSETS IN SYSTEM.NUMBER_TBL_TYPE
2417: , P_INTO_SUBSETS IN SYSTEM.NUMBER_TBL_TYPE
2418: , P_ACTION_TYPE IN VARCHAR2
2419: , X_NUM_PENDING OUT NOCOPY NUMBER
2420: , X_ACTION_ID OUT NOCOPY NUMBER
2421: )

Line 2427: l_into_subsets SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();

2423:
2424: ----------------------------------------------------------------
2425: -- Local copy of the subsets to move entries into.
2426: ----------------------------------------------------------------
2427: l_into_subsets SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();
2428:
2429: ----------------------------------------------------------------
2430: -- Status code used locally.
2431: ----------------------------------------------------------------

Line 2884: SUBSET_INTO_TBL SYSTEM.NUMBER_TBL_TYPE;

2880: -----------------------------++++++-------------------------------
2881: PROCEDURE TEST_TRANSITION
2882: IS
2883: LIST_ID NUMBER;
2884: SUBSET_INTO_TBL SYSTEM.NUMBER_TBL_TYPE;
2885: SUBSET_FROM_TBL SYSTEM.NUMBER_TBL_TYPE;
2886: RETURN_NUM NUMBER;
2887: X_ACTION_ID NUMBER;
2888: BEGIN

Line 2885: SUBSET_FROM_TBL SYSTEM.NUMBER_TBL_TYPE;

2881: PROCEDURE TEST_TRANSITION
2882: IS
2883: LIST_ID NUMBER;
2884: SUBSET_INTO_TBL SYSTEM.NUMBER_TBL_TYPE;
2885: SUBSET_FROM_TBL SYSTEM.NUMBER_TBL_TYPE;
2886: RETURN_NUM NUMBER;
2887: X_ACTION_ID NUMBER;
2888: BEGIN
2889: LIST_ID := 10606;

Line 2890: SUBSET_INTO_TBL := SYSTEM.NUMBER_TBL_TYPE(10041);

2886: RETURN_NUM NUMBER;
2887: X_ACTION_ID NUMBER;
2888: BEGIN
2889: LIST_ID := 10606;
2890: SUBSET_INTO_TBL := SYSTEM.NUMBER_TBL_TYPE(10041);
2891: SUBSET_FROM_TBL := SYSTEM.NUMBER_TBL_TYPE(10028);
2892: TRACELOG(TO_CHAR(SYSDATE, 'MM-DD-YYYY:HH24:MI:SS'));
2893: IEC_SUBSET_PVT.SUBSET_TRANSITION ( 1001
2894: , 10115

Line 2891: SUBSET_FROM_TBL := SYSTEM.NUMBER_TBL_TYPE(10028);

2887: X_ACTION_ID NUMBER;
2888: BEGIN
2889: LIST_ID := 10606;
2890: SUBSET_INTO_TBL := SYSTEM.NUMBER_TBL_TYPE(10041);
2891: SUBSET_FROM_TBL := SYSTEM.NUMBER_TBL_TYPE(10028);
2892: TRACELOG(TO_CHAR(SYSDATE, 'MM-DD-YYYY:HH24:MI:SS'));
2893: IEC_SUBSET_PVT.SUBSET_TRANSITION ( 1001
2894: , 10115
2895: , 0 -- CAMPAIGN_ID