DBA Data[Home] [Help]

APPS.PO_CONTROL_ACTION_VALIDATIONS dependencies on PO_ONLINE_REPORT_TEXT_S

Line 3807: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

3803: p_online_report_id IN NUMBER,
3804: p_action_date IN DATE,
3805: p_login_id IN po_lines.last_update_login%TYPE,
3806: p_user_id IN po_lines.last_updated_by%TYPE,
3807: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
3808: p_key IN po_session_gt.key%TYPE,
3809: x_return_status OUT NOCOPY VARCHAR2,
3810: x_msg_data OUT NOCOPY VARCHAR2)
3811:

Line 4206: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

4202: p_action_date IN DATE,
4203: p_key IN po_session_gt.key%TYPE,
4204: p_login_id IN po_lines.last_update_login%TYPE,
4205: p_user_id IN po_lines.last_updated_by%TYPE,
4206: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4207: p_online_report_id IN NUMBER,
4208: x_return_status OUT NOCOPY VARCHAR2,
4209: x_return_msg OUT NOCOPY VARCHAR2)
4210: IS

Line 4422: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

4418: p_online_report_id IN NUMBER,
4419: p_key IN po_session_gt.key%TYPE,
4420: p_user_id IN po_lines.last_updated_by%TYPE,
4421: p_login_id IN po_lines.last_update_login%TYPE,
4422: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4423: p_agent_id IN PO_HEADERS.agent_id%TYPE,
4424: x_return_status OUT NOCOPY VARCHAR2,
4425: x_return_msg OUT NOCOPY VARCHAR2)
4426:

Line 4624: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

4620: p_online_report_id IN NUMBER,
4621: p_agent_id IN PO_HEADERS.agent_id%TYPE,
4622: p_user_id IN po_lines.last_updated_by%TYPE,
4623: p_login_id IN po_lines.last_update_login%TYPE,
4624: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
4625: p_source IN VARCHAR2 DEFAULT NULL,
4626: p_key IN po_session_gt.key%TYPE,
4627: x_return_status OUT NOCOPY VARCHAR2,
4628: x_return_msg OUT NOCOPY VARCHAR2)

Line 4942: l_sequence po_online_report_text.sequence%TYPE;

4938:
4939: l_progress VARCHAR2(3) := '000' ;
4940: l_line_loc_id_tbl po_tbl_number;
4941: l_line_id_tbl po_tbl_number;
4942: l_sequence po_online_report_text.sequence%TYPE;
4943: l_line_token VARCHAR2(20);
4944: l_ship_token VARCHAR2(20);
4945: l_amt_token VARCHAR2(20);
4946: l_qty_token VARCHAR2(20);

Line 5285: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

5281: p_revert_chg_flag IN VARCHAR2,
5282: p_online_report_id IN NUMBER,
5283: p_user_id IN po_lines.last_updated_by%TYPE,
5284: p_login_id IN po_lines.last_update_login%TYPE,
5285: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5286: p_source IN VARCHAR2 DEFAULT NULL,
5287: p_low_level_key IN po_session_gt.key%TYPE,
5288: p_entity_level_key IN po_session_gt.key%TYPE,
5289: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,

Line 5589: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

5585: x_return_status OUT NOCOPY VARCHAR2,
5586: x_msg_data OUT NOCOPY VARCHAR2,
5587: p_user_id IN po_lines.last_updated_by%TYPE,
5588: p_login_id IN po_lines.last_update_login%TYPE,
5589: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5590: x_cancel_reqs_flag IN OUT NOCOPY VARCHAR2,
5591: p_online_report_id IN NUMBER,
5592: p_doc_type IN VARCHAR2,
5593: p_doc_id IN NUMBER,

Line 5786: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

5782: p_online_report_id IN NUMBER,
5783: p_key IN po_session_gt.key%TYPE,
5784: p_user_id IN po_lines.last_updated_by%TYPE,
5785: p_login_id IN po_lines.last_update_login%TYPE,
5786: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
5787: x_return_status OUT NOCOPY VARCHAR2,
5788: x_return_msg OUT NOCOPY VARCHAR2)
5789: IS
5790:

Line 6253: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,

6249: p_user_id IN po_lines.last_updated_by%TYPE,
6250: p_login_id IN po_lines.last_update_login%TYPE,
6251: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
6252: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,
6253: p_sequence IN OUT NOCOPY po_online_report_text.sequence%TYPE,
6254: x_return_status OUT NOCOPY VARCHAR2,
6255: x_return_msg OUT NOCOPY VARCHAR2)
6256:
6257:

Line 6728: l_sequence po_online_report_text.sequence%TYPE ;

6724:
6725:
6726:
6727: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;
6728: l_sequence po_online_report_text.sequence%TYPE ;
6729:
6730: d_api_name CONSTANT VARCHAR2(30) := 'validate_cancel_action';
6731: d_module CONSTANT VARCHAR2(100) := g_pkg_name || d_api_name;
6732: l_progress VARCHAR2(3) := '000' ;

Line 6757: SELECT PO_ONLINE_REPORT_TEXT_S.nextval

6753:
6754: l_progress := '001';
6755:
6756: --Get the unique id to be used for this document
6757: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
6758: INTO l_online_report_id
6759: FROM sys.dual;
6760:
6761: