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.PORCPTWF dependencies on FND_PROFILE

Line 5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

1: PACKAGE BODY PORCPTWF AS
2: /* $Header: PORCPWFB.pls 120.17.12000000.3 2007/10/22 04:29:07 pilamuru ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7: -- Added parameter to check if distribution data updation is to be skipped
8: Function Populate_Order_Info(itemtype in varchar2,
9: itemkey in varchar2,

Line 140: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

136: x_primary_uom_class VARCHAR2(10);
137: x_item_id NUMBER;
138: x_org_id NUMBER;
139: x_rcv_trans_status VARCHAR2(500) := NULL;
140: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
141: x_insert_txns_status NUMBER;
142: x_auto_receive_flag VARCHAR2(1);
143:
144: t_po_header_id rcvNumberArray;

Line 341: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

337: x_WF_ItemKey VARCHAR2(100);
338: x_WF_ItemKey_save VARCHAR2(100);
339: x_auto_receive_flag VARCHAR2(1);
340: x_WF_process_exists BOOLEAN;
341: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
342: x_wf_itemtype varchar2(6) := 'PORCPT';
343: x_revision_num number;
344: x_internal_req_rcpt Varchar2(1) := FND_PROFILE.value('POR_INTERNAL_CONFIRM_RECEIPT');
345: x_sys_date DATE;

Line 344: x_internal_req_rcpt Varchar2(1) := FND_PROFILE.value('POR_INTERNAL_CONFIRM_RECEIPT');

340: x_WF_process_exists BOOLEAN;
341: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
342: x_wf_itemtype varchar2(6) := 'PORCPT';
343: x_revision_num number;
344: x_internal_req_rcpt Varchar2(1) := FND_PROFILE.value('POR_INTERNAL_CONFIRM_RECEIPT');
345: x_sys_date DATE;
346: x_item_key_count number;
347: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;
348:

Line 573: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

569: x_group_id NUMBER;
570: x_inserted_txn_status NUMBER := 0;
571: x_RCV_txns_rc NUMBER := 0;
572: x_rcv_trans_status VARCHAR2(500) := NULL;
573: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
574:
575: t_req_line_id rcvNumberArray;
576: t_expected_receipt_qty rcvNumberArray;
577: t_ordered_uom rcvVarcharArray;

Line 724: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

720: x_WF_ItemKey VARCHAR2(100);
721: x_WF_ItemKey_save VARCHAR2(100);
722: x_auto_receive_flag VARCHAR2(1);
723: x_WF_process_exists BOOLEAN;
724: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
725: ssp_version VARCHAR2(30) := FND_PROFILE.value('POR_SSP_VERSION');
726: x_ssp_version_gt4 VARCHAR2(10) := 'Y';
727: x_wf_itemtype varchar2(6) := 'PORCPT';
728: x_revision_num number;

Line 725: ssp_version VARCHAR2(30) := FND_PROFILE.value('POR_SSP_VERSION');

721: x_WF_ItemKey_save VARCHAR2(100);
722: x_auto_receive_flag VARCHAR2(1);
723: x_WF_process_exists BOOLEAN;
724: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
725: ssp_version VARCHAR2(30) := FND_PROFILE.value('POR_SSP_VERSION');
726: x_ssp_version_gt4 VARCHAR2(10) := 'Y';
727: x_wf_itemtype varchar2(6) := 'PORCPT';
728: x_revision_num number;
729: x_item_key_count number;

Line 1146: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

1142:
1143: x_revision_num number;
1144: x_org_id number;
1145:
1146: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
1147:
1148:
1149: BEGIN
1150:

Line 1340: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

1336:
1337: x_revision_num number;
1338:
1339:
1340: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
1341:
1342:
1343: BEGIN
1344:

Line 1446: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

1442: x_po_header_ID NUMBER;
1443: x_exp_receipt_date DATE;
1444: x_Rcv_Order_URL VARCHAR2(1000);
1445: x_org_id NUMBER;
1446: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1447:
1448: BEGIN
1449:
1450: IF ( funmode = 'RUN' ) THEN

Line 1521: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

1517: x_so_header_ID NUMBER;
1518: x_exp_receipt_date DATE;
1519: x_Rcv_Order_URL VARCHAR2(1000);
1520: x_org_id NUMBER;
1521: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1522:
1523: BEGIN
1524:
1525: IF ( funmode = 'RUN' ) THEN

Line 1634: AND nvl(fnd_profile.value_specific('ORG_ID', NULL,

1630: and fr.start_date < sysdate
1631: and nvl(fr.end_date, sysdate +1) >= sysdate
1632: and fur.start_date < sysdate
1633: and nvl(fur.end_date, sysdate +1) >= Sysdate
1634: AND nvl(fnd_profile.value_specific('ORG_ID', NULL,
1635: fr.responsibility_id, fur.responsibility_application_id),-1) = nvl(x_org_id,-1)
1636: and nvl(fsp.org_id,-1) = nvl(x_org_id,-1)
1637: and nvl(fsp.business_group_id,-1) =
1638: nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL,

Line 1638: nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL,

1634: AND nvl(fnd_profile.value_specific('ORG_ID', NULL,
1635: fr.responsibility_id, fur.responsibility_application_id),-1) = nvl(x_org_id,-1)
1636: and nvl(fsp.org_id,-1) = nvl(x_org_id,-1)
1637: and nvl(fsp.business_group_id,-1) =
1638: nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL,
1639: fr.responsibility_id, fur.responsibility_application_id),-1);
1640: EXCEPTION
1641: when others then
1642: x_resp_id := -1;

Line 1658: AND nvl(fnd_profile.value_specific('ORG_ID', NULL,

1654: and fr.start_date < sysdate
1655: and nvl(fr.end_date, sysdate +1) >= sysdate
1656: and fur.start_date < sysdate
1657: and nvl(fur.end_date, sysdate +1) >= Sysdate
1658: AND nvl(fnd_profile.value_specific('ORG_ID', NULL,
1659: fr.responsibility_id, fur.responsibility_application_id),-1) = nvl(x_org_id,-1)
1660: and nvl(fsp.org_id,-1) = nvl(x_org_id,-1)
1661: and nvl(fsp.business_group_id,-1) =
1662: nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL,

Line 1662: nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL,

1658: AND nvl(fnd_profile.value_specific('ORG_ID', NULL,
1659: fr.responsibility_id, fur.responsibility_application_id),-1) = nvl(x_org_id,-1)
1660: and nvl(fsp.org_id,-1) = nvl(x_org_id,-1)
1661: and nvl(fsp.business_group_id,-1) =
1662: nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL,
1663: fr.responsibility_id, fur.responsibility_application_id),-1);
1664: EXCEPTION
1665: when others then
1666: x_resp_id := -1;

Line 1685: nvl(fnd_profile.value_specific('ORG_ID', NULL, fr.responsibility_id,

1681: fr.start_date < sysdate and
1682: nvl(fr.end_date, sysdate +1) >= sysdate and
1683: fur.start_date < sysdate and
1684: nvl(fur.end_date, sysdate +1) >= Sysdate AND
1685: nvl(fnd_profile.value_specific('ORG_ID', NULL, fr.responsibility_id,
1686: fur.responsibility_application_id),-1) = nvl(x_org_id,-1) and
1687: nvl(fsp.org_id,-1) = nvl(x_org_id,-1) and
1688: nvl(fsp.business_group_id,-1) =
1689: nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL,

Line 1689: nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL,

1685: nvl(fnd_profile.value_specific('ORG_ID', NULL, fr.responsibility_id,
1686: fur.responsibility_application_id),-1) = nvl(x_org_id,-1) and
1687: nvl(fsp.org_id,-1) = nvl(x_org_id,-1) and
1688: nvl(fsp.business_group_id,-1) =
1689: nvl(fnd_profile.value_specific('PER_BUSINESS_GROUP_ID', NULL,
1690: fr.responsibility_id, fur.responsibility_application_id),-1);
1691: EXCEPTION
1692: WHEN OTHERS THEN
1693: x_resp_appl_id := -1;

Line 1751: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

1747: x_rcv_trans_status VARCHAR2(500) := NULL;
1748: X_tmp_count NUMBER;
1749: X_tmp_count1 NUMBER;
1750: X_tmp_approve VARCHAR2(20);
1751: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
1752: x_insert_txns_status NUMBER;
1753:
1754: t_po_header_id rcvNumberArray;
1755: t_line_location_id rcvNumberArray;

Line 1795: x_allow_inv_dest_receipts := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

1791: aname => 'REQUESTER_USERNAME');
1792: initialize(x_requester_username,x_org_id);
1793:
1794: /** rewrite after initialize **/
1795: x_allow_inv_dest_receipts := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
1796:
1797: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1798: itemkey => itemkey,
1799: aname => 'REQUESTER_ID');

Line 2264: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

2260: x_WF_ItemKey VARCHAR2(100);
2261: x_WF_ItemKey_save VARCHAR2(100);
2262: x_auto_receive_flag VARCHAR2(1);
2263: x_WF_process_exists BOOLEAN;
2264: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2265:
2266: x_wf_itemtype varchar2(6) := 'PORCPT';
2267: x_revision_num number;
2268:

Line 2417: x_allow_inv_dest_receipts varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

2413: x_count NUMBER := 0;
2414: x_org_id NUMBER;
2415: x_requester_id NUMBER;
2416: x_exp_receipt_date DATE;
2417: x_allow_inv_dest_receipts varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2418: x_is_int_req VARCHAR2(1);
2419: x_so_header_id NUMBER;
2420: x_po_header_id NUMBER;
2421:

Line 2585: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

2581: x_header_ID NUMBER;
2582: x_exp_receipt_date DATE;
2583: x_Rcv_Order_URL VARCHAR2(1000);
2584: x_org_id NUMBER;
2585: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2586:
2587: BEGIN
2588:
2589: IF ( funmode = 'RUN' ) THEN

Line 2782: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

2778: x_rcv_trans_status VARCHAR2(500) := NULL;
2779: X_tmp_count NUMBER;
2780: X_tmp_count1 NUMBER;
2781: X_tmp_approve VARCHAR2(20);
2782: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2783:
2784: x_inserted_txn_status NUMBER;
2785: x_org_id NUMBER;
2786:

Line 2823: x_allow_inv_dest_receipts := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

2819:
2820: PORCPTWF.initialize(x_requester_username,x_org_id);
2821:
2822: /** rewrite after initialize **/
2823: x_allow_inv_dest_receipts := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
2824:
2825:
2826: x_requester_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2827: itemkey => itemkey,

Line 3064: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

3060: x_confirm_rcpt_inst VARCHAR2(2000);
3061: x_is_int_req VARCHAR2(1);
3062:
3063: nl VARCHAR2(1) := fnd_global.newline;
3064: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
3065: BEGIN
3066:
3067: x_is_int_req := wf_engine.GetItemAttrText( itemtype => x_item_type,
3068: itemkey => x_item_key,

Line 3186: x_allow_inv_dest_receipts varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

3182: i NUMBER:=0;
3183: l_rcpt_record rcpt_record ;
3184: x_req_number VARCHAR2(20);
3185:
3186: x_allow_inv_dest_receipts varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
3187: NL VARCHAR2(1) := fnd_global.newline;
3188:
3189: BEGIN
3190:

Line 3375: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

3371:
3372: type select_line_info_Cursor is ref cursor ;
3373: Porcpt_LineInfo select_line_info_Cursor;
3374:
3375: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
3376:
3377: NL VARCHAR2(1) := fnd_global.newline;
3378: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
3379:

Line 3378: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');

3374:
3375: x_allow_inv_dest_receipts Varchar2(20) := FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
3376:
3377: NL VARCHAR2(1) := fnd_global.newline;
3378: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
3379:
3380:
3381: BEGIN
3382:

Line 3557: FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');

3553: itemkey in varchar2,
3554: skip_distribution_updation in varchar2 default 'N') Return number
3555: IS
3556: x_allow_inv_dest_receipts Varchar2(20) :=
3557: FND_PROFILE.value('POR_ALLOW_INV_DEST_RECEIPTS');
3558: x_po_header_id NUMBER;
3559: x_org_id NUMBER;
3560: x_requester_id NUMBER;
3561: x_exp_receipt_date DATE;