7: start_date gl_period_statuses.start_date%TYPE,
8: end_date gl_period_statuses.end_date%TYPE,
9: closing_status_meaning gl_lookups.meaning%TYPE,
10: prosessing_status cn_lookups.meaning%TYPE,
11: freeze_flag cn_period_statuses.freeze_flag%TYPE,
12: object_version_number cn_period_statuses.object_version_number%TYPE);
13:
14: TYPE acc_period_tbl_type IS TABLE OF acc_period_rec_type INDEX BY BINARY_INTEGER;
15:
8: end_date gl_period_statuses.end_date%TYPE,
9: closing_status_meaning gl_lookups.meaning%TYPE,
10: prosessing_status cn_lookups.meaning%TYPE,
11: freeze_flag cn_period_statuses.freeze_flag%TYPE,
12: object_version_number cn_period_statuses.object_version_number%TYPE);
13:
14: TYPE acc_period_tbl_type IS TABLE OF acc_period_rec_type INDEX BY BINARY_INTEGER;
15:
16: -- Procedure to start OPEN_PERIODS concurrent request
45: -- x_msg_data OUT VARCHAR2(2000)
46: -- Version : Current version 1.0
47: -- Initial version 1.0
48: --
49: -- Notes : 1) update period_status, insert period record into cn_period_statuses if the
50: -- the corresponding record does not exist in cn_period_statuses
51: --
52: -- End of comments
53:
46: -- Version : Current version 1.0
47: -- Initial version 1.0
48: --
49: -- Notes : 1) update period_status, insert period record into cn_period_statuses if the
50: -- the corresponding record does not exist in cn_period_statuses
51: --
52: -- End of comments
53:
54: PROCEDURE Update_Acc_Periods