eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_HEADERS_ALL

Line 10: g_wf_item_type po_headers_all.wf_item_type%TYPE;

6: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
7: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_DRAFT_MERGE_PKG';
8: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
9:
10: g_wf_item_type po_headers_all.wf_item_type%TYPE;
11: g_wf_item_key po_headers_all.wf_item_key%TYPE;
12: g_debug_stmt CONSTANT BOOLEAN := (PO_DEBUG.is_debug_stmt_on And (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)); /* In Bug# 5028960, Modified to Avoid File.sql.46 error*/
13: g_debug_unexp CONSTANT BOOLEAN := (PO_DEBUG.is_debug_unexp_on AND (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)); /* In Bug# 5028960, Modified to Avoid File.sql.46 error*/
14:

Line 11: g_wf_item_key po_headers_all.wf_item_key%TYPE;

7: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_DRAFT_MERGE_PKG';
8: g_module_prefix CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
9:
10: g_wf_item_type po_headers_all.wf_item_type%TYPE;
11: g_wf_item_key po_headers_all.wf_item_key%TYPE;
12: g_debug_stmt CONSTANT BOOLEAN := (PO_DEBUG.is_debug_stmt_on And (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)); /* In Bug# 5028960, Modified to Avoid File.sql.46 error*/
13: g_debug_unexp CONSTANT BOOLEAN := (PO_DEBUG.is_debug_unexp_on AND (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)); /* In Bug# 5028960, Modified to Avoid File.sql.46 error*/
14:
15: G_MOD_SYNC_LOCK CONSTANT VARCHAR2(20) := 'MOD_SYNC';

Line 1009: FROM po_headers_all

1005: WHERE draft_id = p_draft_id;
1006:
1007: SELECT TYPE_LOOKUP_CODE, STYLE_ID
1008: INTO l_document_type_code, l_document_style_id
1009: FROM po_headers_all
1010: WHERE PO_HEADER_ID = l_po_header_id;
1011:
1012: d_position := 70;
1013: IF PO_LOG.d_stmt THEN

Line 1189: FROM po_headers_all pha

1185: l_base_amount_limit,
1186: l_draft_amount_limit,
1187: l_draft_old_amount_limit,
1188: l_change_status
1189: FROM po_headers_all pha
1190: ,po_headers_draft_all phd
1191: WHERE pha.po_header_id = phd.po_header_id
1192: AND phd.draft_id = p_draft_id
1193: AND pha.po_header_id = l_po_header_id;

Line 1342: FROM po_headers_all poh

1338: poh.attribute15 ,
1339: poh.umbrella_program_id,
1340: poh.revision_num,
1341: poh.clm_payment_instr_code -- Added for reverting PI in headers
1342: FROM po_headers_all poh
1343: WHERE poh.po_header_id = l_po_header_id)
1344: WHERE pohd.po_header_id=l_po_header_id
1345: AND pohd.draft_id = p_draft_id;
1346:

Line 2430: INTO po_headers_all_ext_b phbd

2426: PO_LOG.stmt(d_module,d_position ,'PODraft Header Id', l_po_header_id);
2427: END IF;
2428:
2429: MERGE
2430: INTO po_headers_all_ext_b phbd
2431: USING
2432: (SELECT phb1.extension_id ,
2433: phb1.attr_group_id ,
2434: phb1.po_header_id ,

Line 2539: FROM po_headers_all_ext_b phb1

2535: phb1.d_ext_attr10 ,
2536: phb1.uda_template_id ,
2537: phb1.draft_id ,
2538: phb1.revision_num
2539: FROM po_headers_all_ext_b phb1
2540: WHERE phb1.draft_id = -1
2541: AND phb1.po_header_id = l_po_header_id
2542: -- exclude Mod specific and doc numbering attribute groups
2543: AND NOT EXISTS (SELECT 'Mod specific or doc numbering attribute groups'

Line 2881: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_b for Single Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');

2877:
2878:
2879: d_position := 30;
2880: IF (PO_LOG.d_stmt) THEN
2881: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_b for Single Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
2883: END IF;
2884:
2885: -- Update multi Row header Ext n rev num

Line 2886: DELETE FROM po_headers_all_ext_b pheb

2882: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
2883: END IF;
2884:
2885: -- Update multi Row header Ext n rev num
2886: DELETE FROM po_headers_all_ext_b pheb
2887: WHERE pheb.po_header_id=l_po_header_id
2888: AND pheb.draft_id = p_draft_id
2889: AND (pheb.c_ext_attr40 NOT IN ('PO_UDA_ADDRESS_TYPES', 'PO_MOD_UDA_ADDRESS_TYPES')
2890: OR pheb.c_ext_attr40 IS NULL)

Line 2903: PO_LOG.stmt(d_module,d_position ,'Deleted from po_headers_all_ext_b for Multi Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');

2899: WHERE pheb.attr_group_id = ag.attr_group_id
2900: AND ag.multi_row = 'Y');
2901: d_position := 40;
2902: IF (PO_LOG.d_stmt) THEN
2903: PO_LOG.stmt(d_module,d_position ,'Deleted from po_headers_all_ext_b for Multi Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2904: END IF;
2905:
2906: INSERT INTO po_headers_all_ext_b phbd
2907: ( phbd.extension_id ,

Line 2906: INSERT INTO po_headers_all_ext_b phbd

2902: IF (PO_LOG.d_stmt) THEN
2903: PO_LOG.stmt(d_module,d_position ,'Deleted from po_headers_all_ext_b for Multi Row attr grp and c_ext_attr40 not in PO_UDA_ADDRESS_TYPES');
2904: END IF;
2905:
2906: INSERT INTO po_headers_all_ext_b phbd
2907: ( phbd.extension_id ,
2908: phbd.attr_group_id ,
2909: phbd.po_header_id ,
2910: phbd.data_level_id ,

Line 3122: FROM po_headers_all_ext_b phb --base

3118: phb.d_ext_attr10,
3119: phb.uda_template_id ,
3120: p_draft_id ,
3121: phb.revision_num
3122: FROM po_headers_all_ext_b phb --base
3123: WHERE phb.draft_id = -1
3124: AND phb.po_header_id = l_po_header_id
3125: AND (phb.c_ext_attr40 NOT IN ('PO_UDA_ADDRESS_TYPES', 'PO_MOD_UDA_ADDRESS_TYPES')
3126: OR phb.c_ext_attr40 IS NULL)

Line 3140: PO_LOG.stmt(d_module,d_position ,'Inserted Into po_headers_all_ext_b for Multi Row attr grp from base tables');

3136: AND ag.multi_row = 'Y');
3137:
3138: d_position :=60;
3139: IF (PO_LOG.d_stmt) THEN
3140: PO_LOG.stmt(d_module,d_position ,'Inserted Into po_headers_all_ext_b for Multi Row attr grp from base tables');
3141: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3142: END IF;
3143:
3144:

Line 3148: FROM po_headers_all_ext_b b

3144:
3145: SELECT b.extension_id
3146: BULK COLLECT
3147: INTO l_entension_id_tbl
3148: FROM po_headers_all_ext_b b
3149: WHERE draft_id = p_draft_id
3150: AND po_header_id = l_po_header_id
3151: AND NOT EXISTS (SELECT 'tl table record exists'
3152: FROM po_headers_all_ext_tl tl

Line 3152: FROM po_headers_all_ext_tl tl

3148: FROM po_headers_all_ext_b b
3149: WHERE draft_id = p_draft_id
3150: AND po_header_id = l_po_header_id
3151: AND NOT EXISTS (SELECT 'tl table record exists'
3152: FROM po_headers_all_ext_tl tl
3153: WHERE b.extension_id = tl.extension_id);
3154:
3155: SELECT language_code
3156: INTO l_base_lang

Line 3161: DELETE FROM po_headers_all_ext_tl phaet

3157: FROM fnd_languages
3158: WHERE installed_flag ='B';
3159:
3160:
3161: DELETE FROM po_headers_all_ext_tl phaet
3162: WHERE phaet.po_header_id=l_po_header_id
3163: AND phaet.draft_id = p_draft_id
3164: AND EXISTS (SELECT 'if multi row attr grp'
3165: FROM ego_fnd_dsc_flx_ctx_ext ag

Line 3175: FROM po_headers_all_ext_b phb

3171: AND pel.entity_pk1= phaet.po_header_id
3172: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
3173: AND pel.lock_by_draft_id = p_draft_id )
3174: AND NOT EXISTS (SELECT 'Exclude Uda attributes'
3175: FROM po_headers_all_ext_b phb
3176: WHERE PHB.EXTENSION_ID = phaet.EXTENSION_ID
3177: AND phb.c_ext_attr40 = 'PO_UDA_ADDRESS_TYPES'
3178: );
3179:

Line 3181: INSERT INTO po_headers_all_ext_tl tl

3177: AND phb.c_ext_attr40 = 'PO_UDA_ADDRESS_TYPES'
3178: );
3179:
3180: FORALL i IN 1 .. l_entension_id_tbl.COUNT
3181: INSERT INTO po_headers_all_ext_tl tl
3182: ( tl.extension_id,
3183: tl.attr_group_id,
3184: tl.po_header_id,
3185: tl.source_lang,

Line 3219: FROM po_headers_all_ext_b b,

3215: b.created_by,
3216: b.creation_date ,
3217: b.uda_template_id,
3218: p_draft_id
3219: FROM po_headers_all_ext_b b,
3220: fnd_languages l
3221: WHERE b.extension_id = l_entension_id_tbl(i)
3222: AND l.installed_flag IN ('B', 'I')
3223: ;

Line 3227: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_tl for S or No locks');

3223: ;
3224:
3225: d_position :=70;
3226: IF (PO_LOG.d_stmt) THEN
3227: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_tl for S or No locks');
3228: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3229: END IF;
3230:
3231: d_position := 80;

Line 4477: UPDATE po_headers_all_ext_b phbd

4473: IF (PO_LOG.d_stmt) THEN
4474: PO_LOG.stmt(d_module,d_position ,'Header Id', l_po_header_id);
4475: END IF;
4476:
4477: UPDATE po_headers_all_ext_b phbd
4478: SET ( phbd.c_ext_attr1,
4479: phbd.c_ext_attr2 ,
4480: phbd.c_ext_attr3 ,
4481: phbd.c_ext_attr4 ,

Line 4661: FROM po_headers_all_ext_b phb--base

4657: phb.d_ext_attr8 ,
4658: phb.d_ext_attr9 ,
4659: phb.d_ext_attr10 ,
4660: phb.revision_num
4661: FROM po_headers_all_ext_b phb--base
4662: WHERE phb.po_header_id = phbd.po_header_id
4663: AND phb.draft_id = -1
4664: AND phb.attr_group_id = phbd.attr_group_id
4665: AND phb.c_ext_attr39=phbd.c_ext_attr39

Line 4685: FROM po_headers_all_ext_b phb,

4681: AND pel.entity_pk2= phbd.c_ext_attr39
4682: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_ADDRESS_ENTITY
4683: AND pel.lock_by_draft_id = p_draft_id )
4684: AND EXISTS (SELECT 'base.rev_num>draft.rev_num'
4685: FROM po_headers_all_ext_b phb,
4686: po_drafts dft
4687: WHERE ( (p_ignore_rev_number ='Y') OR (NVL(phb.revision_num,0) > NVL(phbd.revision_num,0) OR NVL(dft.revision_num,0) = -1))
4688: AND phb.draft_id = -1
4689: AND phb.po_header_id=l_po_header_id

Line 4749: l_base_rev_num PO_HEADERS_ALL.revision_num%TYPE;

4745: l_document_id NUMBER;
4746: l_return_status varchar2(1);
4747: l_errormessage varchar2(2000);
4748: l_return_status_mod varchar2(1);
4749: l_base_rev_num PO_HEADERS_ALL.revision_num%TYPE;
4750: l_mod_rev_num PO_HEADERS_ALL.revision_num%TYPE;
4751: BEGIN
4752:
4753: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.sync_with_award_wf: 01';

Line 4750: l_mod_rev_num PO_HEADERS_ALL.revision_num%TYPE;

4746: l_return_status varchar2(1);
4747: l_errormessage varchar2(2000);
4748: l_return_status_mod varchar2(1);
4749: l_base_rev_num PO_HEADERS_ALL.revision_num%TYPE;
4750: l_mod_rev_num PO_HEADERS_ALL.revision_num%TYPE;
4751: BEGIN
4752:
4753: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.sync_with_award_wf: 01';
4754:

Line 4809: FROM po_headers_all

4805: --
4806: -- Sync OKC data only if revision number has changed on the base document
4807: SELECT revision_num
4808: INTO l_base_rev_num
4809: FROM po_headers_all
4810: WHERE po_header_id = l_document_id;
4811:
4812: SELECT revision_num
4813: INTO l_mod_rev_num

Line 4955: l_po_header_id PO_HEADERS_ALL.po_header_id%type;

4951: resultout OUT NOCOPY VARCHAR2) is
4952:
4953: l_draft_id NUMBER;
4954: l_org_id NUMBER;
4955: l_po_header_id PO_HEADERS_ALL.po_header_id%type;
4956: l_doc_sub_type VARCHAR2(10);
4957: l_doc_type VARCHAR2(10);
4958: x_progress varchar2(1000);
4959: l_request_id number;

Line 5111: SELECT revision_num INTO l_header_base_rev_num FROM po_headers_all WHERE po_header_id = l_po_header_id;

5107: FROM po_drafts
5108: WHERE draft_id = l_draft_id;
5109:
5110: SELECT revision_num INTO l_draft_rev_num FROM po_headers_draft_all WHERE po_header_id = l_po_header_id AND draft_id = l_draft_id;
5111: SELECT revision_num INTO l_header_base_rev_num FROM po_headers_all WHERE po_header_id = l_po_header_id;
5112: SELECT revision_num INTO draft_revision_num FROM po_drafts WHERE draft_id = l_draft_id;
5113:
5114: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Draft_id: '
5115: || l_draft_id || 'l_draft_rev_num : '|| l_draft_rev_num || 'l_header_base_rev_num '|| l_header_base_rev_num || 'draft_revision_num '|| draft_revision_num;

Line 5155: l_po_header_id PO_HEADERS_ALL.po_header_id%type;

5151: resultout out NOCOPY varchar2 ) is
5152:
5153: l_draft_id NUMBER;
5154: l_org_id NUMBER;
5155: l_po_header_id PO_HEADERS_ALL.po_header_id%type;
5156: l_doc_sub_type VARCHAR2(10);
5157: l_doc_type VARCHAR2(10);
5158: x_progress varchar2(1000);
5159: l_request_id number;

Line 5189: SELECT revision_num into l_revision_number FROM po_headers_all WHERE po_header_id = l_po_header_id;

5185: l_org_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
5186: itemkey => itemkey,
5187: aname => 'ORG_ID');
5188:
5189: SELECT revision_num into l_revision_number FROM po_headers_all WHERE po_header_id = l_po_header_id;
5190:
5191: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: l_draft_id: '||l_draft_id||', l_po_header_id: '||
5192: l_po_header_id||', l_doc_sub_type: '||l_doc_sub_type||', l_doc_type: '||l_doc_type ||'l_org_id :'|| l_org_id ||
5193: 'l_revision_number '|| l_revision_number;

Line 5202: from po_print_form_formats pf, po_drafts h, po_headers_all h1, fnd_languages f

5198:
5199:
5200: select pf.DOC_FORMAT_TMPL_CODE, f.iso_territory, f.language_code
5201: into l_template_code,l_cd_territory,l_lang_code
5202: from po_print_form_formats pf, po_drafts h, po_headers_all h1, fnd_languages f
5203: where pf.FORM_SOURCE = 'PO' and pf.DOCUMENT_TYPE = 'PO_MOD_STD_FORM' and pf.STANDARD_FORM = h.CLM_STANDARD_FORM
5204: and pf.DOCUMENT_FORMAT = h.CLM_DOCUMENT_FORMAT and h1.po_header_id = h.document_id
5205: and pf.STYLE_ID = h1.STYLE_ID and h.draft_id = l_draft_id and f.language_code = USERENV('LANG');
5206:

Line 5275: WHERE user_key = (SELECT segment1 FROM po_headers_all

5271:
5272: --Select the item keys of the work flow processes which are waiting for MOD_SYNC lock
5273: CURSOR waiting_process_wf_keys(l_draft_id IN Number) IS
5274: SELECT item_key FROM wf_item_activity_statuses_v
5275: WHERE user_key = (SELECT segment1 FROM po_headers_all
5276: WHERE po_header_id = (SELECT document_id
5277: FROM po_drafts
5278: WHERE draft_id = l_draft_id))
5279: AND activity_name = 'WAIT_FOR_LOCK_TO_BE_RELEASED' AND activity_status_code = 'NOTIFIED' ;