DBA Data[Home] [Help]

APPS.PO_DRAFTS_PVT dependencies on PO_TBL_VARCHAR1

Line 2281: ) RETURN PO_TBL_VARCHAR1 IS

2277: --End of Comments
2278: ------------------------------------------------------------------------
2279: FUNCTION changes_exist_for_draft
2280: ( p_draft_id_tbl PO_TBL_NUMBER
2281: ) RETURN PO_TBL_VARCHAR1 IS
2282:
2283: d_api_name CONSTANT VARCHAR2(30) := 'changes_exist_for_draft';
2284: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2285: d_position NUMBER;

Line 2289: l_master_chg_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

2285: d_position NUMBER;
2286:
2287: l_null_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2288:
2289: l_master_chg_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
2290: l_chg_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
2291: BEGIN
2292:
2293: d_position := 0;

Line 2290: l_chg_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

2286:
2287: l_null_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2288:
2289: l_master_chg_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
2290: l_chg_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
2291: BEGIN
2292:
2293: d_position := 0;
2294:

Line 7984: l_lock_by_mod_num_tbl PO_TBL_VARCHAR100;

7980: IS
7981: l_entity_id_tbl PO_TBL_NUMBER;
7982: l_err_entity_tbl PO_TBL_VARCHAR60;
7983: l_err_pk1_tbl PO_TBL_VARCHAR240;
7984: l_lock_by_mod_num_tbl PO_TBL_VARCHAR100;
7985: l_err_msg_name VARCHAR2(60);
7986: d_api_name CONSTANT VARCHAR2(30) := 'identify_header_locks';
7987: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
7988: d_position NUMBER;

Line 7997: l_lock_by_mod_num_tbl:=PO_TBL_VARCHAR100();

7993: BEGIN
7994:
7995: x_return_status := FND_API.G_RET_STS_SUCCESS;
7996: x_results := PO_VALIDATION_RESULTS_TYPE.new_instance();
7997: l_lock_by_mod_num_tbl:=PO_TBL_VARCHAR100();
7998:
7999: d_position:=0;
8000: IF (PO_LOG.d_proc) THEN
8001: PO_LOG.proc_begin(d_module);