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.GMA_PURGE_ENGINE dependencies on SY_PURG_MST

Line 5: (p_purge_id sy_purg_mst.purge_id%TYPE,

1: PACKAGE BODY GMA_PURGE_ENGINE AS
2: /* $Header: GMAPRGEB.pls 120.1.12010000.1 2008/07/30 06:17:23 appldev ship $ */
3:
4: FUNCTION archivecleanup
5: (p_purge_id sy_purg_mst.purge_id%TYPE,
6: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,
7: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
8: p_tablecount INTEGER,
9: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,

Line 19: PROCEDURE report_exit (p_purge_id sy_purg_mst.purge_id%TYPE,

15: p_disable_constraints BOOLEAN,
16: p_debug_flag BOOLEAN)
17: RETURN BOOLEAN;
18:
19: PROCEDURE report_exit (p_purge_id sy_purg_mst.purge_id%TYPE,
20: p_status INTEGER);
21:
22: FUNCTION initarchive
23: (p_purge_id sy_purg_mst.purge_id%TYPE,

Line 23: (p_purge_id sy_purg_mst.purge_id%TYPE,

19: PROCEDURE report_exit (p_purge_id sy_purg_mst.purge_id%TYPE,
20: p_status INTEGER);
21:
22: FUNCTION initarchive
23: (p_purge_id sy_purg_mst.purge_id%TYPE,
24: p_purge_type sy_purg_def.purge_type%TYPE,
25: p_owner user_users.username%TYPE,
26: p_appl_short_name fnd_application.application_short_name%TYPE,
27: p_arctablename user_tables.table_name%TYPE,

Line 41: (p_purge_id sy_purg_mst.purge_id%TYPE,

37: p_debug_flag BOOLEAN)
38: RETURN BOOLEAN;
39:
40: PROCEDURE doarchive
41: (p_purge_id sy_purg_mst.purge_id%TYPE,
42: p_purge_type sy_purg_def.purge_type%TYPE,
43: p_owner user_users.username%TYPE,
44: p_appl_short_name fnd_application.application_short_name%TYPE,
45: p_user NUMBER,

Line 58: (p_purge_id sy_purg_mst.purge_id%TYPE,

54: p_disable_constraints BOOLEAN,
55: p_debug_flag BOOLEAN);
56:
57: PROCEDURE getrows
58: (p_purge_id sy_purg_mst.purge_id%TYPE,
59: p_owner user_users.username%TYPE,
60: p_appl_short_name fnd_application.application_short_name%TYPE,
61: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
62: p_tablespace user_tablespaces.tablespace_name%TYPE,

Line 67: (p_purge_id sy_purg_mst.purge_id%TYPE,

63: p_arcrowtable user_tables.table_name%TYPE,
64: p_debug_flag BOOLEAN);
65:
66: PROCEDURE logresults
67: (p_purge_id sy_purg_mst.purge_id%TYPE,
68: p_user NUMBER,
69: p_arctables_tab GMA_PURGE_DDL.g_tablename_tab_type,
70: p_arcactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
71: p_tablecount INTEGER,

Line 75: PROCEDURE archive(p_purge_id sy_purg_mst.purge_id%TYPE,

71: p_tablecount INTEGER,
72: p_totarchiverows IN OUT NOCOPY INTEGER,
73: p_totdeleterows IN OUT NOCOPY INTEGER);
74:
75: PROCEDURE archive(p_purge_id sy_purg_mst.purge_id%TYPE,
76: p_purge_type sy_purg_def.purge_type%TYPE,
77: p_owner user_users.username%TYPE,
78: p_appl_short_name fnd_application.application_short_name%TYPE,
79: p_user NUMBER,

Line 94: PROCEDURE purge(p_purge_id sy_purg_mst.purge_id%TYPE,

90: p_starttime IN OUT NOCOPY DATE,
91: p_disable_constraints BOOLEAN,
92: p_debug_flag BOOLEAN);
93:
94: PROCEDURE purge(p_purge_id sy_purg_mst.purge_id%TYPE,
95: p_purge_type sy_purg_def.purge_type%TYPE,
96: p_owner user_users.username%TYPE,
97: p_appl_short_name fnd_application.application_short_name%TYPE,
98: p_debug_flag BOOLEAN);

Line 105: (P_Purge_id in sy_purg_mst.purge_id%TYPE,

101: The main purpose of this is not to delete any transaction which have unposted rows in it. */
102:
103: /* added new TEMP TABLE logic */
104: FUNCTION GLPOSTED_OPSO
105: (P_Purge_id in sy_purg_mst.purge_id%TYPE,
106: p_purge_type sy_purg_def.purge_type%TYPE,
107: p_owner user_users.username%TYPE,
108: p_debug_flag BOOLEAN)
109: RETURN LONG;

Line 113: (P_Purge_id in sy_purg_mst.purge_id%TYPE,

109: RETURN LONG;
110:
111: /* added new TEMP TABLE logic */
112: FUNCTION GLPOSTED_JRNL
113: (P_Purge_id in sy_purg_mst.purge_id%TYPE,
114: p_purge_type sy_purg_def.purge_type%TYPE,
115: p_owner user_users.username%TYPE,
116: p_debug_flag BOOLEAN)
117: RETURN LONG;

Line 121: (P_Purge_id in sy_purg_mst.purge_id%TYPE,

117: RETURN LONG;
118:
119: /* added new TEMP TABLE logic */
120: FUNCTION GLPOSTED_PORD
121: (P_Purge_id in sy_purg_mst.purge_id%TYPE,
122: p_purge_type sy_purg_def.purge_type%TYPE,
123: p_owner user_users.username%TYPE,
124: p_debug_flag BOOLEAN)
125: RETURN LONG;

Line 129: (P_Purge_id in sy_purg_mst.purge_id%TYPE,

125: RETURN LONG;
126:
127: /* added new TEMP TABLE logic */
128: FUNCTION GLPOSTED_PROD
129: (P_Purge_id in sy_purg_mst.purge_id%TYPE,
130: p_purge_type sy_purg_def.purge_type%TYPE,
131: p_owner user_users.username%TYPE,
132: p_debug_flag BOOLEAN)
133: RETURN LONG;

Line 137: FUNCTION Tempcreate(p_purge_id sy_purg_mst.purge_id%TYPE,

133: RETURN LONG;
134:
135:
136: -- Create temporary table for PROD and APRD KH
137: FUNCTION Tempcreate(p_purge_id sy_purg_mst.purge_id%TYPE,
138: p_purge_type sy_purg_def.purge_type%TYPE,
139: p_owner user_users.username%TYPE,
140: p_debug_flag BOOLEAN)
141: RETURN CHAR;

Line 144: PROCEDURE Tempinsert(p_purge_id sy_purg_mst.purge_id%TYPE,

140: p_debug_flag BOOLEAN)
141: RETURN CHAR;
142:
143: -- Insert rows in temporary table for PROD and APRD KH
144: PROCEDURE Tempinsert(p_purge_id sy_purg_mst.purge_id%TYPE,
145: p_purge_type sy_purg_def.purge_type%TYPE,
146: p_all_ids number,
147: p_debug_flag BOOLEAN);
148:

Line 150: PROCEDURE Tempdrop(p_purge_id sy_purg_mst.purge_id%TYPE,

146: p_all_ids number,
147: p_debug_flag BOOLEAN);
148:
149: -- Drop the temporary table for PROD and APRD KH
150: PROCEDURE Tempdrop(p_purge_id sy_purg_mst.purge_id%TYPE,
151: p_purge_type sy_purg_def.purge_type%TYPE,
152: p_debug_flag BOOLEAN);
153:
154: -- Drop the temporary table for PROD and APRD KH

Line 155: PROCEDURE ResetTestPurge(p_purge_id sy_purg_mst.purge_id%TYPE,

151: p_purge_type sy_purg_def.purge_type%TYPE,
152: p_debug_flag BOOLEAN);
153:
154: -- Drop the temporary table for PROD and APRD KH
155: PROCEDURE ResetTestPurge(p_purge_id sy_purg_mst.purge_id%TYPE,
156: p_purge_type sy_purg_def.purge_type%TYPE,
157: p_debug_flag varchar2);
158:
159: -- Created a FUNCTION for GSCC standard fix bug 3871659

Line 167: PROCEDURE doarchive(p_purge_id sy_purg_mst.purge_id%TYPE,

163:
164:
165: /***********************************************************/
166:
167: PROCEDURE doarchive(p_purge_id sy_purg_mst.purge_id%TYPE,
168: p_purge_type sy_purg_def.purge_type%TYPE,
169: p_owner user_users.username%TYPE,
170: p_appl_short_name fnd_application.application_short_name%TYPE,
171: p_user NUMBER,

Line 249: UPDATE sy_purg_mst

245: RAISE l_badpurge;
246: END IF;
247:
248: -- log copy time to master record for statistics
249: UPDATE sy_purg_mst
250: SET archive_table_count = (p_tablecount + 1)
251: , copy_elapsed_time =
252: trunc(((sysdate - l_copystarttime) * 86400),2)
253: , last_update_date = sysdate

Line 366: (p_purge_id sy_purg_mst.purge_id%TYPE,

362:
363: /***********************************************************/
364:
365: FUNCTION archivecleanup
366: (p_purge_id sy_purg_mst.purge_id%TYPE,
367: p_tablenames_tab GMA_PURGE_DDL.g_tablename_tab_type,
368: p_tableactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
369: p_tablecount INTEGER,
370: p_indexes_tab GMA_PURGE_DDL.g_statement_tab_type,

Line 419: (p_purge_id sy_purg_mst.purge_id%TYPE,

415:
416: /***********************************************************/
417:
418: FUNCTION initarchive
419: (p_purge_id sy_purg_mst.purge_id%TYPE,
420: p_purge_type sy_purg_def.purge_type%TYPE,
421: p_owner user_users.username%TYPE,
422: p_appl_short_name fnd_application.application_short_name%TYPE,
423: p_arctablename user_tables.table_name%TYPE,

Line 582: p_purge_id IN sy_purg_mst.purge_id%TYPE,

578: /***********************************************************/
579:
580: PROCEDURE main(errbuf OUT NOCOPY VARCHAR2,
581: retcode OUT NOCOPY VARCHAR2,
582: p_purge_id IN sy_purg_mst.purge_id%TYPE,
583: p_appl_short_name IN fnd_application.application_short_name%TYPE,
584: p_job_run IN NUMBER,
585: p_job_name IN VARCHAR2) IS
586:

Line 603: l_status sy_purg_mst.purge_status%TYPE;

599: l_owner user_users.username%TYPE;
600: l_owner_verify user_users.username%TYPE;
601: l_aol_status BOOLEAN;
602:
603: l_status sy_purg_mst.purge_status%TYPE;
604: l_testarcstatus sy_purg_mst.status%TYPE;
605: -- You know it.
606: l_orastatus sy_purg_mst.ora_status%TYPE;
607: -- Not that we're expecting trouble or anything.

Line 604: l_testarcstatus sy_purg_mst.status%TYPE;

600: l_owner_verify user_users.username%TYPE;
601: l_aol_status BOOLEAN;
602:
603: l_status sy_purg_mst.purge_status%TYPE;
604: l_testarcstatus sy_purg_mst.status%TYPE;
605: -- You know it.
606: l_orastatus sy_purg_mst.ora_status%TYPE;
607: -- Not that we're expecting trouble or anything.
608:

Line 606: l_orastatus sy_purg_mst.ora_status%TYPE;

602:
603: l_status sy_purg_mst.purge_status%TYPE;
604: l_testarcstatus sy_purg_mst.status%TYPE;
605: -- You know it.
606: l_orastatus sy_purg_mst.ora_status%TYPE;
607: -- Not that we're expecting trouble or anything.
608:
609: -- dummy variables.
610: l_app_status VARCHAR2(50);

Line 614: CURSOR l_arccursor_cur(c_purge_id sy_purg_mst.purge_id%TYPE) IS

610: l_app_status VARCHAR2(50);
611: l_app_industry VARCHAR2(50);
612:
613: -- funky little cheats
614: CURSOR l_arccursor_cur(c_purge_id sy_purg_mst.purge_id%TYPE) IS
615: SELECT SM.purge_type purgetype
616: , SD.sqlstatement arcsqlstatement
617: -- , NVL(SD.work_tablespace,
618: , UU.default_tablespace arctablespace

Line 627: , sy_purg_mst SM

623: , nvl(SM.calculate_storage_flag,'F') storage_flag
624: , nvl(SM.commit_frequency,750) commit_frequency
625: , nvl(SM.object_owner,'') object_owner
626: FROM dba_users UU
627: , sy_purg_mst SM
628: , sy_purg_def SD
629: WHERE SD.purge_type (+) = SM.purge_type
630: AND UU.username = 'GMA'
631: AND SM.purge_id = c_purge_id;

Line 634: CURSOR l_critcursor_cur(c_purge_id sy_purg_mst.purge_id%TYPE) IS

630: AND UU.username = 'GMA'
631: AND SM.purge_id = c_purge_id;
632:
633: -- Made BY KHAJA FROM user_users UU
634: CURSOR l_critcursor_cur(c_purge_id sy_purg_mst.purge_id%TYPE) IS
635:
636: SELECT DC.crit_tag crit_tag
637: , REPLACE(NVL(DC.value_mask,'{X}'),
638: '{X}',

Line 640: FROM sy_purg_mst_crit MC

636: SELECT DC.crit_tag crit_tag
637: , REPLACE(NVL(DC.value_mask,'{X}'),
638: '{X}',
639: NVL(MC.crit_value,DC.default_value)) value
640: FROM sy_purg_mst_crit MC
641: , sy_purg_def_crit DC
642: , sy_purg_mst MS
643: WHERE MC.crit_tag = DC.crit_tag
644: AND MC.purge_id = MS.purge_id

Line 642: , sy_purg_mst MS

638: '{X}',
639: NVL(MC.crit_value,DC.default_value)) value
640: FROM sy_purg_mst_crit MC
641: , sy_purg_def_crit DC
642: , sy_purg_mst MS
643: WHERE MC.crit_tag = DC.crit_tag
644: AND MC.purge_id = MS.purge_id
645: AND DC.purge_type = MS.purge_type
646: AND MS.purge_id = c_purge_id;

Line 823: UPDATE sy_purg_mst

819: END IF;
820:
821: if P_JOB_RUN in (1,2) then
822:
823: UPDATE sy_purg_mst
824: SET purge_status = l_status
825: , last_update_date = sysdate
826: , last_updated_by = l_user
827: , archive_start_time = decode(l_status,1,sysdate,archive_start_time)

Line 836: UPDATE sy_purg_mst

832: COMMIT;
833:
834: elsif P_JOB_RUN in (3,4,5) then
835: -- added by KH for test type
836: UPDATE sy_purg_mst
837: SET status = l_status
838: , last_update_date = sysdate
839: , last_updated_by = l_user
840: , archive_start_time = decode(l_status,1,sysdate,archive_start_time)

Line 1011: UPDATE sy_purg_mst

1007: end if;
1008:
1009: if P_JOB_RUN in (1,2) then
1010:
1011: UPDATE sy_purg_mst
1012: -- SET rows_archived = decode(l_status,1,l_totarchiverows, rows_archived)
1013: SET rows_deleted = decode(l_status,1,l_totdeleterows,
1014: rows_deleted)
1015: , archive_elapsed_time =

Line 1031: UPDATE sy_purg_mst

1027: , last_update_date = sysdate
1028: , last_updated_by = l_user
1029: WHERE purge_id = p_purge_id;
1030: elsif P_JOB_RUN in (3,4,5) then
1031: UPDATE sy_purg_mst
1032: SET rows_archived = decode(l_status,1,l_totarchiverows,
1033: rows_archived)
1034: -- , rows_deleted = decode(l_status,1,l_totdeleterows,
1035: -- rows_deleted)

Line 1067: UPDATE sy_purg_mst

1063: l_elapsed:=1;
1064: end if;
1065:
1066:
1067: UPDATE sy_purg_mst
1068: SET purge_elapsed_time =
1069: decode(l_status,3,l_elapsed,purge_elapsed_time)
1070: , last_update_date = sysdate
1071: , last_updated_by = l_user

Line 1096: UPDATE sy_purg_mst

1092:
1093: if P_JOB_RUN in (1,2) then
1094:
1095: -- Added by Khaja to place the actual Archive time
1096: UPDATE sy_purg_mst
1097: SET purge_status = l_status
1098: , archive_start_time=to_date(pa_initiate_time,'DD-MM-YYYY HH24:MI:SS')
1099: , last_update_date = sysdate
1100: , last_updated_by = l_user

Line 1105: UPDATE sy_purg_mst

1101: WHERE purge_id = p_purge_id;
1102:
1103: COMMIT;
1104: elsif P_JOB_RUN in(3,4,5) then
1105: UPDATE sy_purg_mst
1106: SET status = l_status
1107: , archive_start_time=to_date(pa_initiate_time,'DD-MM-YYYY HH24:MI:SS')
1108: , last_update_date = sysdate
1109: , last_updated_by = l_user

Line 1132: UPDATE sy_purg_mst

1128: GMA_PURGE_UTILITIES.printlong(p_purge_id,
1129: 'Not Purging, No posted Rows found.');
1130: if P_JOB_RUN in (1,2) then
1131:
1132: UPDATE sy_purg_mst
1133: SET purge_status = 0
1134: , last_update_date = sysdate
1135: , last_updated_by = l_user
1136: , archive_start_time = decode(l_status,1,sysdate,archive_start_time)

Line 1144: UPDATE sy_purg_mst

1140: COMMIT;
1141:
1142: elsif P_JOB_RUN in (3,4,5) then
1143: -- added by KH for test type
1144: UPDATE sy_purg_mst
1145: SET status = 0
1146: , last_update_date = sysdate
1147: , last_updated_by = l_user
1148: , archive_start_time = decode(l_status,1,sysdate,archive_start_time)

Line 1168: UPDATE sy_purg_mst SY

1164:
1165: l_orastatus := sqlcode;
1166:
1167: if P_JOB_RUN in (1,2) then
1168: UPDATE sy_purg_mst SY
1169: SET SY.purge_status = (SY.purge_status - (SY.purge_status * 2))
1170: , SY.ora_status = l_orastatus
1171: WHERE SY.purge_id = p_purge_id;
1172: elsif P_JOB_RUN in(3,4,5) then

Line 1173: UPDATE sy_purg_mst SY

1169: SET SY.purge_status = (SY.purge_status - (SY.purge_status * 2))
1170: , SY.ora_status = l_orastatus
1171: WHERE SY.purge_id = p_purge_id;
1172: elsif P_JOB_RUN in(3,4,5) then
1173: UPDATE sy_purg_mst SY
1174: SET SY.status = (SY.status - (SY.status * 2))
1175: , SY.ora_status = l_orastatus
1176: WHERE SY.purge_id = p_purge_id;
1177: end if;

Line 1187: PROCEDURE getrows(p_purge_id sy_purg_mst.purge_id%TYPE,

1183: END main;
1184:
1185: /***********************************************************/
1186:
1187: PROCEDURE getrows(p_purge_id sy_purg_mst.purge_id%TYPE,
1188: p_owner user_users.username%TYPE,
1189: p_appl_short_name fnd_application.application_short_name%TYPE,
1190: p_sqlstatement sy_purg_def.sqlstatement%TYPE,
1191: p_tablespace user_tablespaces.tablespace_name%TYPE,

Line 1245: PROCEDURE logresults(p_purge_id sy_purg_mst.purge_id%TYPE,

1241: END getrows;
1242:
1243: /***********************************************************/
1244:
1245: PROCEDURE logresults(p_purge_id sy_purg_mst.purge_id%TYPE,
1246: p_user NUMBER,
1247: p_arctables_tab GMA_PURGE_DDL.g_tablename_tab_type,
1248: p_arcactions_tab GMA_PURGE_DDL.g_tableaction_tab_type,
1249: p_tablecount INTEGER,

Line 1350: PROCEDURE archive(p_purge_id sy_purg_mst.purge_id%TYPE,

1346: END logresults;
1347:
1348: /***********************************************************/
1349:
1350: PROCEDURE archive(p_purge_id sy_purg_mst.purge_id%TYPE,
1351: p_purge_type sy_purg_def.purge_type%TYPE,
1352: p_owner user_users.username%TYPE,
1353: p_appl_short_name fnd_application.application_short_name%TYPE,
1354: p_user NUMBER,

Line 1396: UPDATE sy_purg_mst

1392: GMA_PURGE_UTILITIES.printlong(p_purge_id,
1393: GMA_PURGE_ENGINE.PA_OPTION_NAME||' rows determined in ' ||
1394: TO_CHAR(trunc((p_inittime - p_starttime) * 86400)) || ' seconds.');
1395:
1396: UPDATE sy_purg_mst
1397: SET selection_elapsed_time =
1398: trunc((p_inittime - p_starttime) * 86400)
1399: , last_update_date = sysdate
1400: , last_updated_by = p_user

Line 1470: PROCEDURE purge(p_purge_id sy_purg_mst.purge_id%TYPE,

1466: END archive;
1467:
1468: /***********************************************************/
1469:
1470: PROCEDURE purge(p_purge_id sy_purg_mst.purge_id%TYPE,
1471: p_purge_type sy_purg_def.purge_type%TYPE,
1472: p_owner user_users.username%TYPE,
1473: p_appl_short_name fnd_application.application_short_name%TYPE,
1474: p_debug_flag BOOLEAN) IS

Line 1477: CURSOR l_viewtables_cur(c_purge_type sy_purg_mst.purge_type%TYPE) IS

1473: p_appl_short_name fnd_application.application_short_name%TYPE,
1474: p_debug_flag BOOLEAN) IS
1475: -- drop archive tables, reset views
1476:
1477: CURSOR l_viewtables_cur(c_purge_type sy_purg_mst.purge_type%TYPE) IS
1478: SELECT table_name
1479: FROM sy_purg_def_act
1480: WHERE purge_type = c_purge_type;
1481:

Line 1503: PROCEDURE report_exit (p_purge_id sy_purg_mst.purge_id%TYPE,

1499: END purge;
1500:
1501: /***********************************************************/
1502:
1503: PROCEDURE report_exit (p_purge_id sy_purg_mst.purge_id%TYPE,
1504: p_status INTEGER) IS
1505: BEGIN
1506:
1507: GMA_PURGE_UTILITIES.printlong(p_purge_id,

Line 1522: FUNCTION GLPOSTED_OPSO(P_Purge_id in sy_purg_mst.purge_id%TYPE,

1518: RAISE;
1519:
1520: END report_exit;
1521:
1522: FUNCTION GLPOSTED_OPSO(P_Purge_id in sy_purg_mst.purge_id%TYPE,
1523: p_purge_type sy_purg_def.purge_type%TYPE,
1524: p_owner user_users.username%TYPE,
1525: p_debug_flag BOOLEAN)
1526: RETURN LONG

Line 1530: from sy_purg_mst_crit

1526: RETURN LONG
1527: is
1528: cursor purge_crit is
1529: select crit_tag,crit_value
1530: from sy_purg_mst_crit
1531: where purge_id=P_Purge_id;
1532:
1533: cursor c1(P_MINORDER op_ordr_hdr.order_no%type,
1534: P_MAXORDER op_ordr_hdr.order_no%type,

Line 1678: FUNCTION GLPOSTED_JRNL(P_Purge_id in sy_purg_mst.purge_id%TYPE,

1674: 'Unhandled EXCEPTION - ' || sqlerrm);
1675: end if;
1676: END GLPOSTED_OPSO;
1677:
1678: FUNCTION GLPOSTED_JRNL(P_Purge_id in sy_purg_mst.purge_id%TYPE,
1679: p_purge_type sy_purg_def.purge_type%TYPE,
1680: p_owner user_users.username%TYPE,
1681: p_debug_flag BOOLEAN)
1682: RETURN LONG

Line 1686: from sy_purg_mst_crit

1682: RETURN LONG
1683: is
1684: cursor purge_crit is
1685: select crit_tag,crit_value
1686: from sy_purg_mst_crit
1687: where purge_id=P_Purge_id;
1688:
1689: cursor c1(P_MINJRNL ic_jrnl_mst.journal_no%type,
1690: P_MAXJRNL ic_jrnl_mst.journal_no%type,

Line 1814: (P_Purge_id sy_purg_mst.purge_id%TYPE,

1810: end if;
1811: END GLPOSTED_JRNL;
1812:
1813: FUNCTION GLPOSTED_PROD
1814: (P_Purge_id sy_purg_mst.purge_id%TYPE,
1815: p_purge_type sy_purg_def.purge_type%TYPE,
1816: p_owner user_users.username%TYPE,
1817: p_debug_flag BOOLEAN)
1818: RETURN LONG

Line 1827: from sy_purg_mst_crit

1823: --Ignore GL_POSTED_IND for UPDATE_INVENTORY_IND flag is set to off 'Y' and purge.
1824:
1825: cursor purge_crit is
1826: select crit_tag,crit_value
1827: from sy_purg_mst_crit
1828: where purge_id=P_Purge_id;
1829:
1830: cursor c1(P_MINBATCH gme_batch_header.batch_no%type,
1831: P_MAXBATCH gme_batch_header.batch_no%type,

Line 2013: FUNCTION GLPOSTED_PORD(P_Purge_id in sy_purg_mst.purge_id%TYPE,

2009:
2010:
2011: END GLPOSTED_PROD;
2012:
2013: FUNCTION GLPOSTED_PORD(P_Purge_id in sy_purg_mst.purge_id%TYPE,
2014: p_purge_type sy_purg_def.purge_type%TYPE,
2015: p_owner user_users.username%TYPE,
2016: p_debug_flag BOOLEAN)
2017: RETURN LONG

Line 2022: from sy_purg_mst_crit

2018:
2019: is
2020: cursor purge_crit is
2021: select crit_tag,crit_value
2022: from sy_purg_mst_crit
2023: where purge_id=P_Purge_id;
2024:
2025: cursor c1(P_MINPO po_ordr_hdr.po_no%type,
2026: P_MAXPO po_ordr_hdr.po_no%type,

Line 2143: FUNCTION Tempcreate(p_purge_id sy_purg_mst.purge_id%TYPE,

2139: 'Unhandled EXCEPTION - ' || sqlerrm);
2140: end if;
2141: END GLPOSTED_PORD;
2142:
2143: FUNCTION Tempcreate(p_purge_id sy_purg_mst.purge_id%TYPE,
2144: p_purge_type sy_purg_def.purge_type%TYPE,
2145: p_owner user_users.username%TYPE,
2146: p_debug_flag BOOLEAN) RETURN CHAR
2147: IS

Line 2234: PROCEDURE Tempinsert(p_purge_id sy_purg_mst.purge_id%TYPE,

2230: RAISE;
2231:
2232: END tempcreate;
2233:
2234: PROCEDURE Tempinsert(p_purge_id sy_purg_mst.purge_id%TYPE,
2235: p_purge_type sy_purg_def.purge_type%TYPE,
2236: p_all_ids number,
2237: p_debug_flag BOOLEAN)
2238: IS

Line 2304: PROCEDURE Tempdrop(p_purge_id sy_purg_mst.purge_id%TYPE,

2300: RAISE;
2301:
2302: END tempinsert;
2303:
2304: PROCEDURE Tempdrop(p_purge_id sy_purg_mst.purge_id%TYPE,
2305: p_purge_type sy_purg_def.purge_type%TYPE,
2306: p_debug_flag BOOLEAN)
2307: IS
2308:

Line 2374: PROCEDURE ResetTestPurge(p_purge_id sy_purg_mst.purge_id%TYPE,

2370: RAISE;
2371:
2372: END Tempdrop;
2373:
2374: PROCEDURE ResetTestPurge(p_purge_id sy_purg_mst.purge_id%TYPE,
2375: p_purge_type sy_purg_def.purge_type%TYPE,
2376: p_debug_flag varchar2)
2377: IS
2378: --Prepare the SQL to get all table_names which needs to be renamed based on the

Line 2380: Cursor Cur_dropTbl(ppurge_id sy_purg_mst.purge_id%TYPE,

2376: p_debug_flag varchar2)
2377: IS
2378: --Prepare the SQL to get all table_names which needs to be renamed based on the
2379: --archive_action equal to 'K'
2380: Cursor Cur_dropTbl(ppurge_id sy_purg_mst.purge_id%TYPE,
2381: c_schema_name VARCHAR2) is
2382: SELECT owner,table_name
2383: FROM all_tables
2384: WHERE owner = c_schema_name

Line 2388: FROM SY_PURG_MST A, Sy_purg_def_act B

2384: WHERE owner = c_schema_name
2385: AND
2386: table_name IN(
2387: SELECT 'T' ||LPAD(TO_CHAR(A.purge_id),5,'0')||'_'||B.table_name
2388: FROM SY_PURG_MST A, Sy_purg_def_act B
2389: WHERE A.purge_type=B.purge_type AND A.purge_id=ppurge_id
2390: union
2391: SELECT 'T'||LPAD(TO_CHAR(A.purge_id),5,'0')||'_'||'ARCHIVEROWS'
2392: FROM SY_PURG_MST A

Line 2392: FROM SY_PURG_MST A

2388: FROM SY_PURG_MST A, Sy_purg_def_act B
2389: WHERE A.purge_type=B.purge_type AND A.purge_id=ppurge_id
2390: union
2391: SELECT 'T'||LPAD(TO_CHAR(A.purge_id),5,'0')||'_'||'ARCHIVEROWS'
2392: FROM SY_PURG_MST A
2393: WHERE A.purge_id=ppurge_id
2394: union
2395: SELECT 'T'||LPAD(TO_CHAR(A.purge_id),5,'0')||'_'||'TEMP'
2396: FROM SY_PURG_MST A

Line 2396: FROM SY_PURG_MST A

2392: FROM SY_PURG_MST A
2393: WHERE A.purge_id=ppurge_id
2394: union
2395: SELECT 'T'||LPAD(TO_CHAR(A.purge_id),5,'0')||'_'||'TEMP'
2396: FROM SY_PURG_MST A
2397: WHERE A.purge_id=ppurge_id
2398: );
2399:
2400:

Line 2430: Update sy_purg_mst set status=0 where purge_id=P_purge_id;

2426: l_cursor := DBMS_SQL.OPEN_CURSOR;
2427: FOR rec in Cur_DropTbl(P_purge_id, l_schema_name)
2428: Loop
2429: if l_rows=0 then
2430: Update sy_purg_mst set status=0 where purge_id=P_purge_id;
2431: commit;
2432: l_rows:=1;
2433: end if;
2434: