DBA Data[Home] [Help]

APPS.PO_AUTO_DIST_PROCESS_PVT dependencies on PO_PERIODS_SV

Line 223: calling PO_PERIODS_SV.get_period_name to make it consistent.

219: AND (x_gl_date_option <> 'REQ GL DATE')
220: AND (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL)) THEN
221: l_progress := '090';
222: /*Bug13553227. eliminated the sql to derive the period name.
223: calling PO_PERIODS_SV.get_period_name to make it consistent.
224: If the get_period_name does not return a period then we will call build_GL_Encumbered_Date in case of PO:validate GL period = 'Redefault'*/
225: l_progress := 50;
226: PO_PERIODS_SV.get_period_name( x_sob_id => PO_AUTOCREATE_PARAMS.g_sys.sob_id ,
227: x_gl_date => SYSDATE ,

Line 226: PO_PERIODS_SV.get_period_name( x_sob_id => PO_AUTOCREATE_PARAMS.g_sys.sob_id ,

222: /*Bug13553227. eliminated the sql to derive the period name.
223: calling PO_PERIODS_SV.get_period_name to make it consistent.
224: If the get_period_name does not return a period then we will call build_GL_Encumbered_Date in case of PO:validate GL period = 'Redefault'*/
225: l_progress := 50;
226: PO_PERIODS_SV.get_period_name( x_sob_id => PO_AUTOCREATE_PARAMS.g_sys.sob_id ,
227: x_gl_date => SYSDATE ,
228: x_gl_period => PO_AUTOCREATE_PARAMS.g_sys.period_name );
229:
230:

Line 236: PO_PERIODS_SV.build_GL_Encumbered_Date(l_sob_id => PO_AUTOCREATE_PARAMS.g_sys.sob_id

232: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
233: l_progress := 60;
234: IF l_validate_gl_period = 'R' THEN
235:
236: PO_PERIODS_SV.build_GL_Encumbered_Date(l_sob_id => PO_AUTOCREATE_PARAMS.g_sys.sob_id
237: ,x_gl_date => x_gl_date
238: ,x_gl_period => PO_AUTOCREATE_PARAMS.g_sys.period_name);
239:
240: END IF;

Line 967: calling PO_PERIODS_SV.get_period_name to make it consistent.

963: -- derive period name if it isn't already known
964: d_progress := 40;
965:
966: /*Bug13553227. eliminated the sql to derive the period name.
967: calling PO_PERIODS_SV.get_period_name to make it consistent.
968: If the get_period_name does not return a period then we will call build_GL_Encumbered_Date in case of PO:validate GL period = 'Redefault'*/
969: SELECT prd.set_of_books_id
970: INTO l_sob_id
971: FROM po_req_distributions_all prd

Line 976: PO_PERIODS_SV.get_period_name( x_sob_id => l_sob_id ,

972: WHERE prd.requisition_line_id = p_lines.requisition_line_id_tbl(i)
973: AND ROWNUM = 1;
974:
975: d_progress := 50;
976: PO_PERIODS_SV.get_period_name( x_sob_id => l_sob_id ,
977: x_gl_date => SYSDATE ,
978: x_gl_period => PO_AUTOCREATE_PARAMS.g_sys.period_name );
979:
980: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN

Line 984: PO_PERIODS_SV.build_GL_Encumbered_Date(l_sob_id => l_sob_id

980: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
981: d_progress := 60;
982: IF l_validate_gl_period = 'R' THEN
983:
984: PO_PERIODS_SV.build_GL_Encumbered_Date(l_sob_id => l_sob_id
985: ,x_gl_date => x_gl_date
986: ,x_gl_period => PO_AUTOCREATE_PARAMS.g_sys.period_name);
987:
988: END IF;

Line 1175: PO_PERIODS_SV.get_period_name( x_sob_id => PO_AUTOCREATE_PARAMS.g_sys.sob_id ,

1171: IF ((PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag = 'Y') AND (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL)) THEN
1172: -- derive period name if it isn't already known
1173: d_progress := 80;
1174: /*Bug13553227 start */
1175: PO_PERIODS_SV.get_period_name( x_sob_id => PO_AUTOCREATE_PARAMS.g_sys.sob_id ,
1176: x_gl_date => SYSDATE ,
1177: x_gl_period => PO_AUTOCREATE_PARAMS.g_sys.period_name );
1178:
1179: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN

Line 1183: PO_PERIODS_SV.build_GL_Encumbered_Date(l_sob_id => PO_AUTOCREATE_PARAMS.g_sys.sob_id

1179: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
1180: d_progress := 85;
1181: IF l_validate_gl_period = 'R' THEN
1182:
1183: PO_PERIODS_SV.build_GL_Encumbered_Date(l_sob_id => PO_AUTOCREATE_PARAMS.g_sys.sob_id
1184: ,x_gl_date => x_gl_date
1185: ,x_gl_period => PO_AUTOCREATE_PARAMS.g_sys.period_name);
1186:
1187: END IF;