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.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_ARCHIVE_HISTORY

Line 17: g_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;

13: g_update_login igc_cc_headers.last_update_login%TYPE;
14: g_update_by igc_cc_headers.last_updated_by%TYPE;
15: g_mrc_installed VARCHAR2(1);
16: g_mode VARCHAR2(2);
17: g_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
18: g_org_id igc_cc_headers.org_id%TYPE;
19: g_sob_id igc_cc_headers.set_of_books_id%TYPE;
20: g_cc_num igc_cc_headers.cc_num%TYPE;
21: g_maxloops CONSTANT NUMBER(2) := 20;

Line 49: p_last_activity_date IN igc_cc_archive_history.user_req_last_activity_date%TYPE,

45: PROCEDURE Arch_Pur_CC
46: (
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_last_activity_date IN igc_cc_archive_history.user_req_last_activity_date%TYPE,
50: p_mode IN VARCHAR2,
51: p_debug_flag IN VARCHAR2 := FND_API.G_FALSE,
52: p_commit_work IN VARCHAR2 := FND_API.G_FALSE,
53: x_Return_Status OUT NOCOPY VARCHAR2

Line 109: p_cc_header_id IN igc_cc_archive_history.cc_header_id%TYPE,

105: --
106: -- Initializing History Record procedure
107: --
108: PROCEDURE Initialize_History_Record (
109: p_cc_header_id IN igc_cc_archive_history.cc_header_id%TYPE,
110: p_History_Rec IN OUT NOCOPY igc_cc_archive_history%ROWTYPE,
111: x_Return_Status OUT NOCOPY VARCHAR2
112: );
113:

Line 110: p_History_Rec IN OUT NOCOPY igc_cc_archive_history%ROWTYPE,

106: -- Initializing History Record procedure
107: --
108: PROCEDURE Initialize_History_Record (
109: p_cc_header_id IN igc_cc_archive_history.cc_header_id%TYPE,
110: p_History_Rec IN OUT NOCOPY igc_cc_archive_history%ROWTYPE,
111: x_Return_Status OUT NOCOPY VARCHAR2
112: );
113:
114: --

Line 161: p_History_Rec IN igc_cc_archive_history%ROWTYPE, -- History Record

157: -- Procedure for Updating the CC ARCHIVE History table
158: --
159: PROCEDURE Update_History
160: (
161: p_History_Rec IN igc_cc_archive_history%ROWTYPE, -- History Record
162: x_Return_Status OUT NOCOPY VARCHAR2 -- Status of procedure
163: );
164:
165: --

Line 393: p_last_activity_date IN igc_cc_archive_history.user_req_last_activity_date%TYPE,

389: PROCEDURE Arch_Pur_CC
390: (
391: p_api_version IN NUMBER,
392: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
393: p_last_activity_date IN igc_cc_archive_history.user_req_last_activity_date%TYPE,
394: p_mode IN VARCHAR2,
395: p_debug_flag IN VARCHAR2 := FND_API.G_FALSE,
396: p_commit_work IN VARCHAR2 := FND_API.G_FALSE,
397: x_Return_Status OUT NOCOPY VARCHAR2

Line 3976: -- p_History_Rec ==> Record that is to be returned initialized for IGC_CC_ARCHIVE_HISTORY table

3972: --
3973: -- Parameters :
3974: --
3975: -- p_cc_header_id ==> CC Header ID to be archived / purged and added to the History Record
3976: -- p_History_Rec ==> Record that is to be returned initialized for IGC_CC_ARCHIVE_HISTORY table
3977: -- x_Return_Status ==> Status of procedure returned to caller
3978: --
3979: PROCEDURE Initialize_History_Record (
3980: p_cc_header_id IN igc_cc_archive_history.cc_header_id%TYPE,

Line 3980: p_cc_header_id IN igc_cc_archive_history.cc_header_id%TYPE,

3976: -- p_History_Rec ==> Record that is to be returned initialized for IGC_CC_ARCHIVE_HISTORY table
3977: -- x_Return_Status ==> Status of procedure returned to caller
3978: --
3979: PROCEDURE Initialize_History_Record (
3980: p_cc_header_id IN igc_cc_archive_history.cc_header_id%TYPE,
3981: p_History_Rec IN OUT NOCOPY igc_cc_archive_history%ROWTYPE,
3982: x_Return_Status OUT NOCOPY VARCHAR2
3983: ) IS
3984:

Line 3981: p_History_Rec IN OUT NOCOPY igc_cc_archive_history%ROWTYPE,

3977: -- x_Return_Status ==> Status of procedure returned to caller
3978: --
3979: PROCEDURE Initialize_History_Record (
3980: p_cc_header_id IN igc_cc_archive_history.cc_header_id%TYPE,
3981: p_History_Rec IN OUT NOCOPY igc_cc_archive_history%ROWTYPE,
3982: x_Return_Status OUT NOCOPY VARCHAR2
3983: ) IS
3984:
3985: l_api_name CONSTANT VARCHAR2(30) := 'Initialize_History_Record';

Line 3986: l_head_id igc_cc_archive_history.cc_header_id%TYPE;

3982: x_Return_Status OUT NOCOPY VARCHAR2
3983: ) IS
3984:
3985: l_api_name CONSTANT VARCHAR2(30) := 'Initialize_History_Record';
3986: l_head_id igc_cc_archive_history.cc_header_id%TYPE;
3987: l_sob_id igc_cc_archive_history.set_of_books_id%TYPE;
3988: l_org_id igc_cc_archive_history.org_id%TYPE;
3989: l_parent_id igc_cc_archive_history.parent_header_id%TYPE;
3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;

Line 3987: l_sob_id igc_cc_archive_history.set_of_books_id%TYPE;

3983: ) IS
3984:
3985: l_api_name CONSTANT VARCHAR2(30) := 'Initialize_History_Record';
3986: l_head_id igc_cc_archive_history.cc_header_id%TYPE;
3987: l_sob_id igc_cc_archive_history.set_of_books_id%TYPE;
3988: l_org_id igc_cc_archive_history.org_id%TYPE;
3989: l_parent_id igc_cc_archive_history.parent_header_id%TYPE;
3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;
3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;

Line 3988: l_org_id igc_cc_archive_history.org_id%TYPE;

3984:
3985: l_api_name CONSTANT VARCHAR2(30) := 'Initialize_History_Record';
3986: l_head_id igc_cc_archive_history.cc_header_id%TYPE;
3987: l_sob_id igc_cc_archive_history.set_of_books_id%TYPE;
3988: l_org_id igc_cc_archive_history.org_id%TYPE;
3989: l_parent_id igc_cc_archive_history.parent_header_id%TYPE;
3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;
3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;

Line 3989: l_parent_id igc_cc_archive_history.parent_header_id%TYPE;

3985: l_api_name CONSTANT VARCHAR2(30) := 'Initialize_History_Record';
3986: l_head_id igc_cc_archive_history.cc_header_id%TYPE;
3987: l_sob_id igc_cc_archive_history.set_of_books_id%TYPE;
3988: l_org_id igc_cc_archive_history.org_id%TYPE;
3989: l_parent_id igc_cc_archive_history.parent_header_id%TYPE;
3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;
3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;

Line 3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;

3986: l_head_id igc_cc_archive_history.cc_header_id%TYPE;
3987: l_sob_id igc_cc_archive_history.set_of_books_id%TYPE;
3988: l_org_id igc_cc_archive_history.org_id%TYPE;
3989: l_parent_id igc_cc_archive_history.parent_header_id%TYPE;
3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;
3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;

Line 3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;

3987: l_sob_id igc_cc_archive_history.set_of_books_id%TYPE;
3988: l_org_id igc_cc_archive_history.org_id%TYPE;
3989: l_parent_id igc_cc_archive_history.parent_header_id%TYPE;
3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;
3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;

Line 3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;

3988: l_org_id igc_cc_archive_history.org_id%TYPE;
3989: l_parent_id igc_cc_archive_history.parent_header_id%TYPE;
3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;
3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;
3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;

Line 3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;

3989: l_parent_id igc_cc_archive_history.parent_header_id%TYPE;
3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;
3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;
3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;
3997: l_archive_done igc_cc_archive_history.archive_done_flag%TYPE;

Line 3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;

3990: l_cc_type igc_cc_archive_history.cc_type%TYPE;
3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;
3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;
3997: l_archive_done igc_cc_archive_history.archive_done_flag%TYPE;
3998: l_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;

Line 3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;

3991: l_lines_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;
3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;
3997: l_archive_done igc_cc_archive_history.archive_done_flag%TYPE;
3998: l_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
3999: l_created_by igc_cc_archive_history.created_by%TYPE;

Line 3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;

3992: l_pf_lines_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;
3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;
3997: l_archive_done igc_cc_archive_history.archive_done_flag%TYPE;
3998: l_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
3999: l_created_by igc_cc_archive_history.created_by%TYPE;
4000: l_created_date igc_cc_archive_history.creation_date%TYPE;

Line 3997: l_archive_done igc_cc_archive_history.archive_done_flag%TYPE;

3993: l_mc_lines_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;
3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;
3997: l_archive_done igc_cc_archive_history.archive_done_flag%TYPE;
3998: l_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
3999: l_created_by igc_cc_archive_history.created_by%TYPE;
4000: l_created_date igc_cc_archive_history.creation_date%TYPE;
4001:

Line 3998: l_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;

3994: l_mc_pf_lines_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;
3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;
3997: l_archive_done igc_cc_archive_history.archive_done_flag%TYPE;
3998: l_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
3999: l_created_by igc_cc_archive_history.created_by%TYPE;
4000: l_created_date igc_cc_archive_history.creation_date%TYPE;
4001:
4002: -- --------------------------------------------------------------------

Line 3999: l_created_by igc_cc_archive_history.created_by%TYPE;

3995: l_archive_date igc_cc_archive_history.archive_date%TYPE;
3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;
3997: l_archive_done igc_cc_archive_history.archive_done_flag%TYPE;
3998: l_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
3999: l_created_by igc_cc_archive_history.created_by%TYPE;
4000: l_created_date igc_cc_archive_history.creation_date%TYPE;
4001:
4002: -- --------------------------------------------------------------------
4003: -- Declare cursors to be used by this procedure.

Line 4000: l_created_date igc_cc_archive_history.creation_date%TYPE;

3996: l_update_by igc_cc_archive_history.last_updated_by%TYPE;
3997: l_archive_done igc_cc_archive_history.archive_done_flag%TYPE;
3998: l_last_activity_date igc_cc_archive_history.user_req_last_activity_date%TYPE;
3999: l_created_by igc_cc_archive_history.created_by%TYPE;
4000: l_created_date igc_cc_archive_history.creation_date%TYPE;
4001:
4002: -- --------------------------------------------------------------------
4003: -- Declare cursors to be used by this procedure.
4004: -- --------------------------------------------------------------------

Line 4022: FROM IGC_CC_ARCHIVE_HISTORY CAH

4018: archive_done_flag,
4019: user_req_last_activity_date,
4020: created_by,
4021: creation_date
4022: FROM IGC_CC_ARCHIVE_HISTORY CAH
4023: WHERE CAH.cc_header_id = p_cc_header_id
4024: AND CAH.org_id = g_org_id
4025: AND CAH.set_of_books_id = g_sob_id;
4026:

Line 4201: l_history_rec igc_cc_archive_history%ROWTYPE;

4197: l_return_status VARCHAR2(1);
4198: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
4199: l_cc_type igc_cc_headers.cc_type%TYPE;
4200: l_parent_id igc_cc_headers.parent_header_id%TYPE;
4201: l_history_rec igc_cc_archive_history%ROWTYPE;
4202: l_max_date igc_arc_pur_candidates.last_activity_date%TYPE;
4203:
4204: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Archive_History';
4205:

Line 4827: l_num_mc_acct_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;

4823: -- --------------------------------------------------------------------
4824: -- Declare local variables to be used in this procedure.
4825: -- --------------------------------------------------------------------
4826: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
4827: l_num_mc_acct_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4828: l_num_mc_pf_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
4829: l_num_mc_acct_pur igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4830: l_num_mc_pf_pur igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
4831: l_api_name CONSTANT VARCHAR2(30) := 'Purge_MRC_Tbls';

Line 4828: l_num_mc_pf_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;

4824: -- Declare local variables to be used in this procedure.
4825: -- --------------------------------------------------------------------
4826: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
4827: l_num_mc_acct_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4828: l_num_mc_pf_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
4829: l_num_mc_acct_pur igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4830: l_num_mc_pf_pur igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
4831: l_api_name CONSTANT VARCHAR2(30) := 'Purge_MRC_Tbls';
4832:

Line 4829: l_num_mc_acct_pur igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;

4825: -- --------------------------------------------------------------------
4826: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
4827: l_num_mc_acct_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4828: l_num_mc_pf_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
4829: l_num_mc_acct_pur igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4830: l_num_mc_pf_pur igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
4831: l_api_name CONSTANT VARCHAR2(30) := 'Purge_MRC_Tbls';
4832:
4833: -- --------------------------------------------------------------------

Line 4830: l_num_mc_pf_pur igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;

4826: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
4827: l_num_mc_acct_arc igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4828: l_num_mc_pf_arc igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
4829: l_num_mc_acct_pur igc_cc_archive_history.num_mc_acct_lines_arc%TYPE;
4830: l_num_mc_pf_pur igc_cc_archive_history.num_mc_det_pf_lines_arc%TYPE;
4831: l_api_name CONSTANT VARCHAR2(30) := 'Purge_MRC_Tbls';
4832:
4833: -- --------------------------------------------------------------------
4834: -- Declare any cursors to be used.

Line 4839: FROM igc_cc_archive_history

4835: -- --------------------------------------------------------------------
4836: CURSOR c_get_arc_hist_info IS
4837: SELECT num_mc_acct_lines_arc,
4838: num_mc_det_pf_lines_arc
4839: FROM igc_cc_archive_history
4840: WHERE cc_header_id = l_cc_header_id
4841: AND set_of_books_id = g_sob_id
4842: AND org_id = g_org_id
4843: AND archive_done_flag = 'Y';

Line 5193: l_num_acct_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;

5189: -- Declare local variables to be used in this procedure.
5190: -- --------------------------------------------------------------------
5191: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
5192: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
5193: l_num_acct_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
5194: l_num_pf_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5195: l_num_acct_pur igc_cc_archive_history.num_acct_lines_arc%TYPE;
5196: l_num_pf_pur igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5197: l_api_name CONSTANT VARCHAR2(30) := 'Purge_NON_MRC_Tbls';

Line 5194: l_num_pf_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;

5190: -- --------------------------------------------------------------------
5191: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
5192: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
5193: l_num_acct_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
5194: l_num_pf_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5195: l_num_acct_pur igc_cc_archive_history.num_acct_lines_arc%TYPE;
5196: l_num_pf_pur igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5197: l_api_name CONSTANT VARCHAR2(30) := 'Purge_NON_MRC_Tbls';
5198: l_history_rec igc_cc_archive_history%ROWTYPE;

Line 5195: l_num_acct_pur igc_cc_archive_history.num_acct_lines_arc%TYPE;

5191: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
5192: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
5193: l_num_acct_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
5194: l_num_pf_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5195: l_num_acct_pur igc_cc_archive_history.num_acct_lines_arc%TYPE;
5196: l_num_pf_pur igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5197: l_api_name CONSTANT VARCHAR2(30) := 'Purge_NON_MRC_Tbls';
5198: l_history_rec igc_cc_archive_history%ROWTYPE;
5199: l_return_status VARCHAR2(1);

Line 5196: l_num_pf_pur igc_cc_archive_history.num_det_pf_lines_arc%TYPE;

5192: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
5193: l_num_acct_arc igc_cc_archive_history.num_acct_lines_arc%TYPE;
5194: l_num_pf_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5195: l_num_acct_pur igc_cc_archive_history.num_acct_lines_arc%TYPE;
5196: l_num_pf_pur igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5197: l_api_name CONSTANT VARCHAR2(30) := 'Purge_NON_MRC_Tbls';
5198: l_history_rec igc_cc_archive_history%ROWTYPE;
5199: l_return_status VARCHAR2(1);
5200:

Line 5198: l_history_rec igc_cc_archive_history%ROWTYPE;

5194: l_num_pf_arc igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5195: l_num_acct_pur igc_cc_archive_history.num_acct_lines_arc%TYPE;
5196: l_num_pf_pur igc_cc_archive_history.num_det_pf_lines_arc%TYPE;
5197: l_api_name CONSTANT VARCHAR2(30) := 'Purge_NON_MRC_Tbls';
5198: l_history_rec igc_cc_archive_history%ROWTYPE;
5199: l_return_status VARCHAR2(1);
5200:
5201: -- --------------------------------------------------------------------
5202: -- Declare any cursors to be used.

Line 5207: FROM igc_cc_archive_history

5203: -- --------------------------------------------------------------------
5204: CURSOR c_get_arc_hist_info IS
5205: SELECT num_acct_lines_arc,
5206: num_det_pf_lines_arc
5207: FROM igc_cc_archive_history
5208: WHERE cc_header_id = l_cc_header_id
5209: /* AND set_of_books_id = g_sob_id
5210: AND org_id = g_org_id --Commented for MOAC uptake */
5211: AND archive_done_flag = 'Y';

Line 5666: -- p_History_Rec ==> Record to be inserted into the IGC_CC_ARCHIVE_HISTORY table

5662: -- record into the appropriate History table.
5663: --
5664: -- Parameters :
5665: --
5666: -- p_History_Rec ==> Record to be inserted into the IGC_CC_ARCHIVE_HISTORY table
5667: -- x_Return_Status ==> Status of procedure returned to caller
5668: --
5669: PROCEDURE Update_History
5670: (

Line 5671: p_History_Rec IN igc_cc_archive_history%ROWTYPE, -- History Record

5667: -- x_Return_Status ==> Status of procedure returned to caller
5668: --
5669: PROCEDURE Update_History
5670: (
5671: p_History_Rec IN igc_cc_archive_history%ROWTYPE, -- History Record
5672: x_Return_Status OUT NOCOPY VARCHAR2 -- Status of procedure
5673: ) IS
5674:
5675: -- --------------------------------------------------------------------

Line 5680: FROM igc_cc_archive_history CAH

5676: -- Declare cursors to be used in this procedure.
5677: -- --------------------------------------------------------------------
5678: CURSOR c_archive_history IS
5679: SELECT CAH.cc_header_id
5680: FROM igc_cc_archive_history CAH
5681: WHERE CAH.cc_header_id = p_History_Rec.cc_header_id
5682: AND CAH.cc_num = p_History_Rec.cc_num
5683: AND CAH.cc_type = p_History_Rec.cc_type;
5684: /* AND CAH.org_id = p_History_Rec.org_id

Line 5690: l_header_id igc_cc_archive_history.cc_header_id%TYPE;

5686:
5687: -- --------------------------------------------------------------------
5688: -- Declare local variables to be used in this procedure.
5689: -- --------------------------------------------------------------------
5690: l_header_id igc_cc_archive_history.cc_header_id%TYPE;
5691: l_api_name CONSTANT VARCHAR2(30) := 'Update_History';
5692:
5693: l_full_path VARCHAR2(255);
5694: BEGIN

Line 5712: -- IGC_CC_ARCHIVE_HISTORY. If there is already a record present then

5708: END IF;
5709:
5710: -- --------------------------------------------------------------------
5711: -- Determine if there is already a record present in the table
5712: -- IGC_CC_ARCHIVE_HISTORY. If there is already a record present then
5713: -- update the record otherwise insert a new record.
5714: -- --------------------------------------------------------------------
5715: OPEN c_archive_history;
5716:

Line 5734: INTO IGC_CC_ARCHIVE_HISTORY_ALL

5730: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5731: END IF;
5732:
5733: INSERT
5734: INTO IGC_CC_ARCHIVE_HISTORY_ALL
5735: ( cc_header_id,
5736: set_of_books_id,
5737: org_id,
5738: parent_header_id,

Line 5810: UPDATE IGC_CC_ARCHIVE_HISTORY AH

5806:
5807: -- --------------------------------------------------------------------
5808: -- Update the existing fields in the history table for non MRC record.
5809: -- --------------------------------------------------------------------
5810: UPDATE IGC_CC_ARCHIVE_HISTORY AH
5811: SET last_update_date = p_History_Rec.last_update_date,
5812: last_updated_by = p_History_Rec.last_updated_by,
5813: purge_done_flag = p_History_Rec.purge_done_flag,
5814: purge_date = p_History_Rec.purge_date,