APPS.OKI_LOAD_FBO_PVT dependencies on OKI_FORECAST_BY_ORGS

Line 49: FROM oki_forecast_by_orgs fbo

45: , p_authoring_org_id IN NUMBER
46: , p_scs_code IN VARCHAR2
47: ) IS
48: SELECT rowid
49: FROM oki_forecast_by_orgs fbo
50: WHERE fbo.period_set_name = p_period_set_name
51: AND fbo.period_name = p_period_name
52: AND fbo.authoring_org_id = p_authoring_org_id
53: AND fbo.scs_code = p_scs_code

Line 58: -- Procedure to insert records into the oki_forecast_by_orgs table.

54: ;
55: rec_g_fbo_csr g_fbo_csr%ROWTYPE ;
56:
57: --------------------------------------------------------------------------------
58: -- Procedure to insert records into the oki_forecast_by_orgs table.
59:
60: --------------------------------------------------------------------------------
61: PROCEDURE ins_fcst_by_org
62: ( p_period_name IN VARCHAR2

Line 83: SELECT oki_forecast_by_orgs_s1.nextval seq

79: l_sequence NUMBER := NULL ;
80:
81: -- Cursor declaration
82: CURSOR l_seq_num IS
83: SELECT oki_forecast_by_orgs_s1.nextval seq
84: FROM dual
85: ;
86: rec_l_seq_num l_seq_num%ROWTYPE ;
87:

Line 102: INSERT INTO oki_forecast_by_orgs

98:
99: -- initialize return code to success
100: x_retcode := '0';
101:
102: INSERT INTO oki_forecast_by_orgs
103: ( id
104: , period_name
105: , period_set_name
106: , period_type

Line 142: , value => 'OKI_FORECAST_BY_ORGS');

138: fnd_message.set_name( application => 'OKI'
139: , name => 'OKI_TABLE_LOAD_FAILURE');
140:
141: fnd_message.set_token( token => 'TABLE_NAME'
142: , value => 'OKI_FORECAST_BY_ORGS');
143:
144: fnd_file.put_line( which => fnd_file.log
145: , buff => fnd_message.get);
146:

Line 152: -- Procedure to update records in the oki_forecast_by_orgs table.

148: , buff => l_sqlcode||' '||l_sqlerrm );
149: END ins_fcst_by_org ;
150:
151: --------------------------------------------------------------------------------
152: -- Procedure to update records in the oki_forecast_by_orgs table.
153:
154: --------------------------------------------------------------------------------
155: PROCEDURE upd_fcst_by_org
156: ( p_base_forecast_amount IN NUMBER

Line 174: UPDATE oki_forecast_by_orgs SET

170:
171: -- initialize return code to success
172: x_retcode := '0';
173:
174: UPDATE oki_forecast_by_orgs SET
175: base_forecast_amount = p_base_forecast_amount
176: , base_booked_amount = p_base_booked_amount
177: , request_id = oki_load_fbo_pvt.g_request_id
178: , program_application_id = oki_load_fbo_pvt.g_program_application_id

Line 235: -- holds the rowid of the record in the oki_forecast_by_orgs table

231: -- Holds the calculated forecast and booked amounts
232: l_base_forecast_amount NUMBER := 0 ;
233: l_base_booked_amount NUMBER := 0 ;
234:
235: -- holds the rowid of the record in the oki_forecast_by_orgs table
236: l_fbo_rowid ROWID ;
237:
238: -- Location within the program before the error was encountered.
239: l_loc VARCHAR2(100) ;

Line 460: -- holds the rowid of the record in the oki_forecast_by_orgs table

456: -- Holds the calculated forecast and booked amounts
457: l_base_forecast_amount NUMBER := 0 ;
458: l_base_booked_amount NUMBER := 0 ;
459:
460: -- holds the rowid of the record in the oki_forecast_by_orgs table
461: l_fbo_rowid ROWID ;
462:
463: -- Location within the program before the error was encountered.
464: l_loc VARCHAR2(100) ;

Line 673: l_table_name CONSTANT VARCHAR2(30) := 'OKI_FORECAST_BY_ORGS' ;

669:
670: -- Constant declaration
671:
672: -- Name of the table for which data is being inserted
673: l_table_name CONSTANT VARCHAR2(30) := 'OKI_FORECAST_BY_ORGS' ;
674:
675:
676: -- Local variable declaration
677: