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.OE_ORDER_WF_UTIL dependencies on WF_ENGINE

Line 260: l_item_key := TO_NUMBER (wf_engine.setctx_itemkey);

256: NULL;
257: WHEN NO_DATA_FOUND
258: THEN
259: -- if viewing method is email
260: l_item_key := TO_NUMBER (wf_engine.setctx_itemkey);
261: --ame er 16084377
262: END; -- End Changes for bug 8570400
263: END;
264:

Line 276: wf_engine.getitemattrnumber ('OEAME', l_item_key, 'HEADER_ID');

272:
273: IF l_item_type = 'OEAME'
274: THEN --ame er 16084377
275: l_header_id :=
276: wf_engine.getitemattrnumber ('OEAME', l_item_key, 'HEADER_ID');
277: ELSE
278: l_header_id := TO_NUMBER (l_item_key);
279: END IF; --ame er 16084377
280:

Line 394: l_line_id := TO_NUMBER (wf_engine.setctx_itemkey);

390: NULL;
391: WHEN NO_DATA_FOUND
392: THEN
393: -- if viewing method is email
394: l_line_id := TO_NUMBER (wf_engine.setctx_itemkey);
395: END; -- End Changes for bug 8570400
396: END;
397:
398: SELECT header_id, line_number, shipment_number, option_number,

Line 524: -- This procedure starts the flow, by calling WF_ENGINE utilities.

520: RAISE fnd_api.g_exc_unexpected_error;
521: END IF;
522: END set_line_user_key;
523:
524: -- This procedure starts the flow, by calling WF_ENGINE utilities.
525: --
526: PROCEDURE start_flow (p_itemtype IN VARCHAR2, p_itemkey IN VARCHAR2)
527: IS
528: --

Line 537: wf_engine.startprocess (p_itemtype, p_itemkey);

533: THEN
534: oe_debug_pub.ADD ('IN START_FLOW');
535: END IF;
536:
537: wf_engine.startprocess (p_itemtype, p_itemkey);
538:
539: IF l_debug_level > 0
540: THEN
541: oe_debug_pub.ADD ('EXITING START_FLOW');

Line 564: wf_engine.startforkprocess ('OEOL', p_itemkey);

560: THEN
561: oe_debug_pub.ADD ('IN START_LINEFORK');
562: END IF;
563:
564: wf_engine.startforkprocess ('OEOL', p_itemkey);
565:
566: -- Refresh old notifications here if needed.
567: IF l_debug_level > 0
568: THEN

Line 650: l_aname wf_engine.nametabtyp;

646: --
647: PROCEDURE create_hdrworkitem (p_header_rec IN oe_order_pub.header_rec_type)
648: IS
649: l_hdr_process_name VARCHAR2 (30);
650: l_aname wf_engine.nametabtyp;
651: l_aname2 wf_engine.nametabtyp;
652: l_avalue wf_engine.numtabtyp;
653: l_avaluetext wf_engine.texttabtyp;
654: sales_order VARCHAR2 (240);

Line 651: l_aname2 wf_engine.nametabtyp;

647: PROCEDURE create_hdrworkitem (p_header_rec IN oe_order_pub.header_rec_type)
648: IS
649: l_hdr_process_name VARCHAR2 (30);
650: l_aname wf_engine.nametabtyp;
651: l_aname2 wf_engine.nametabtyp;
652: l_avalue wf_engine.numtabtyp;
653: l_avaluetext wf_engine.texttabtyp;
654: sales_order VARCHAR2 (240);
655: l_user_name VARCHAR2 (100);

Line 652: l_avalue wf_engine.numtabtyp;

648: IS
649: l_hdr_process_name VARCHAR2 (30);
650: l_aname wf_engine.nametabtyp;
651: l_aname2 wf_engine.nametabtyp;
652: l_avalue wf_engine.numtabtyp;
653: l_avaluetext wf_engine.texttabtyp;
654: sales_order VARCHAR2 (240);
655: l_user_name VARCHAR2 (100);
656: l_validate_user NUMBER;

Line 653: l_avaluetext wf_engine.texttabtyp;

649: l_hdr_process_name VARCHAR2 (30);
650: l_aname wf_engine.nametabtyp;
651: l_aname2 wf_engine.nametabtyp;
652: l_avalue wf_engine.numtabtyp;
653: l_avaluetext wf_engine.texttabtyp;
654: sales_order VARCHAR2 (240);
655: l_user_name VARCHAR2 (100);
656: l_validate_user NUMBER;
657: l_owner_role VARCHAR2 (100);

Line 686: wf_engine.createprocess (oe_globals.g_wfi_hdr,

682: FROM fnd_user
683: WHERE user_id = fnd_global.user_id;
684:
685: -- Create Header Work item
686: wf_engine.createprocess (oe_globals.g_wfi_hdr,
687: TO_CHAR (p_header_rec.header_id),
688: l_hdr_process_name,
689: sales_order,
690: l_owner_role

Line 692: wf_engine.additemattr (oe_globals.g_wfi_hdr,

688: l_hdr_process_name,
689: sales_order,
690: l_owner_role
691: );
692: wf_engine.additemattr (oe_globals.g_wfi_hdr,
693: TO_CHAR (p_header_rec.header_id),
694: '#WAITFORDETAIL',
695: NULL,
696: 0

Line 701: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');

697: );
698:
699: IF l_debug_level > 0
700: THEN
701: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');
702: END IF;
703:
704: -- Set various Header Attributes
705: l_aname (1) := 'USER_ID';

Line 715: wf_engine.setitemattrnumberarray (oe_globals.g_wfi_hdr,

711: l_aname (4) := 'ORG_ID';
712: l_avalue (4) := TO_NUMBER (oe_globals.g_org_id);
713: l_aname (5) := 'ORDER_NUMBER';
714: l_avalue (5) := p_header_rec.order_number;
715: wf_engine.setitemattrnumberarray (oe_globals.g_wfi_hdr,
716: p_header_rec.header_id,
717: l_aname,
718: l_avalue
719: );

Line 748: wf_engine.setitemattrtextarray (oe_globals.g_wfi_hdr,

744: || 'akRegionApplicationId=660'
745: || '&'
746: || 'HeaderId='
747: || TO_CHAR (p_header_rec.header_id);
748: wf_engine.setitemattrtextarray (oe_globals.g_wfi_hdr,
749: p_header_rec.header_id,
750: l_aname2,
751: l_avaluetext
752: );

Line 899: l_aname wf_engine.nametabtyp;

895: IS
896: l_line_process_name VARCHAR2 (30);
897: l_item_type VARCHAR2 (30);
898: l_order_number NUMBER;
899: l_aname wf_engine.nametabtyp;
900: l_aname2 wf_engine.nametabtyp;
901: l_avalue wf_engine.numtabtyp;
902: l_avaluetext wf_engine.texttabtyp;
903: line VARCHAR2 (240);

Line 900: l_aname2 wf_engine.nametabtyp;

896: l_line_process_name VARCHAR2 (30);
897: l_item_type VARCHAR2 (30);
898: l_order_number NUMBER;
899: l_aname wf_engine.nametabtyp;
900: l_aname2 wf_engine.nametabtyp;
901: l_avalue wf_engine.numtabtyp;
902: l_avaluetext wf_engine.texttabtyp;
903: line VARCHAR2 (240);
904: l_owner_role VARCHAR2 (100);

Line 901: l_avalue wf_engine.numtabtyp;

897: l_item_type VARCHAR2 (30);
898: l_order_number NUMBER;
899: l_aname wf_engine.nametabtyp;
900: l_aname2 wf_engine.nametabtyp;
901: l_avalue wf_engine.numtabtyp;
902: l_avaluetext wf_engine.texttabtyp;
903: line VARCHAR2 (240);
904: l_owner_role VARCHAR2 (100);
905: --

Line 902: l_avaluetext wf_engine.texttabtyp;

898: l_order_number NUMBER;
899: l_aname wf_engine.nametabtyp;
900: l_aname2 wf_engine.nametabtyp;
901: l_avalue wf_engine.numtabtyp;
902: l_avaluetext wf_engine.texttabtyp;
903: line VARCHAR2 (240);
904: l_owner_role VARCHAR2 (100);
905: --
906: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 937: wf_engine.createprocess (oe_globals.g_wfi_lin,

933: FROM fnd_user
934: WHERE user_id = fnd_global.user_id;
935:
936: -- Create Line Work item
937: wf_engine.createprocess (oe_globals.g_wfi_lin,
938: TO_CHAR (p_line_rec.line_id),
939: l_line_process_name,
940: line,
941: l_owner_role

Line 946: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');

942: );
943:
944: IF l_debug_level > 0
945: THEN
946: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');
947: END IF;
948:
949: -- Set various Line Attributes
950: l_aname (1) := 'USER_ID';

Line 958: wf_engine.setitemattrnumberarray (oe_globals.g_wfi_lin,

954: l_aname (3) := 'RESPONSIBILITY_ID';
955: l_avalue (3) := fnd_global.resp_id;
956: l_aname (4) := 'ORG_ID';
957: l_avalue (4) := TO_NUMBER (oe_globals.g_org_id);
958: wf_engine.setitemattrnumberarray (oe_globals.g_wfi_lin,
959: p_line_rec.line_id,
960: l_aname,
961: l_avalue
962: );

Line 967: wf_engine.setitemattrtextarray (oe_globals.g_wfi_lin,

963: l_aname2 (1) := 'LINE_CATEGORY';
964: l_avaluetext (1) := p_line_rec.line_category_code;
965: l_aname2 (2) := 'NOTIFICATION_APPROVER';
966: l_avaluetext (2) := fnd_profile.VALUE ('OE_NOTIFICATION_APPROVER');
967: wf_engine.setitemattrtextarray (oe_globals.g_wfi_lin,
968: p_line_rec.line_id,
969: l_aname2,
970: l_avaluetext
971: );

Line 1013: wf_engine.createforkprocess ('OEOL',

1009: END IF;
1010:
1011: set_line_user_key (p_line_rec);
1012: line := SUBSTRB (fnd_message.get, 1, 240);
1013: wf_engine.createforkprocess ('OEOL',
1014: p_line_rec.split_from_line_id,
1015: p_line_rec.line_id,
1016: TRUE,
1017: TRUE

Line 1019: wf_engine.setitemuserkey (oe_globals.g_wfi_lin, p_line_rec.line_id,

1015: p_line_rec.line_id,
1016: TRUE,
1017: TRUE
1018: );
1019: wf_engine.setitemuserkey (oe_globals.g_wfi_lin, p_line_rec.line_id,
1020: line);
1021:
1022: IF l_debug_level > 0
1023: THEN

Line 1286: wf_engine.abortprocess

1282:
1283: IF oe_globals.g_start_line_flows_tbl (ctr).post_write_ato_line_id <>
1284: l_ato_line_id
1285: THEN
1286: wf_engine.abortprocess
1287: (itemtype => oe_globals.g_wfi_lin,
1288: itemkey => oe_globals.g_start_line_flows_tbl
1289: (ctr).line_id
1290: );

Line 1484: wf_engine.itemstatus (itemtype => oe_globals.g_wfi_hdr,

1480:
1481: IF l_count > 0
1482: THEN
1483: --End of 12609242
1484: wf_engine.itemstatus (itemtype => oe_globals.g_wfi_hdr,
1485: itemkey => p_id,
1486: status => l_status,
1487: RESULT => l_result
1488: );

Line 1492: wf_engine.abortprocess (itemtype => oe_globals.g_wfi_hdr,

1488: );
1489:
1490: IF l_status <> 'COMPLETE'
1491: THEN
1492: wf_engine.abortprocess (itemtype => oe_globals.g_wfi_hdr,
1493: itemkey => p_id
1494: );
1495: END IF;
1496:

Line 1536: wf_engine.itemstatus (itemtype => oe_globals.g_wfi_lin,

1532:
1533: IF l_count > 0
1534: THEN
1535: --End of 12609242
1536: wf_engine.itemstatus (itemtype => oe_globals.g_wfi_lin,
1537: itemkey => p_id,
1538: status => l_status,
1539: RESULT => l_result
1540: );

Line 1545: wf_engine.abortprocess (itemtype => oe_globals.g_wfi_lin,

1541:
1542: --Added the nvl condition to fix bug 2333095
1543: IF NVL (l_status, 'ACTIVE') <> 'COMPLETE'
1544: THEN
1545: wf_engine.abortprocess (itemtype => oe_globals.g_wfi_lin,
1546: itemkey => p_id
1547: );
1548: END IF;
1549:

Line 1573: wf_engine.itemstatus (itemtype => oe_globals.g_wfi_ngo,

1569:
1570: IF l_count > 0
1571: THEN
1572: --End of 13020709
1573: wf_engine.itemstatus (itemtype => oe_globals.g_wfi_ngo,
1574: itemkey => p_id,
1575: status => l_status,
1576: RESULT => l_result
1577: );

Line 1581: wf_engine.abortprocess (itemtype => oe_globals.g_wfi_ngo,

1577: );
1578:
1579: IF NVL (l_status, 'ACTIVE') <> 'COMPLETE'
1580: THEN
1581: wf_engine.abortprocess (itemtype => oe_globals.g_wfi_ngo,
1582: itemkey => p_id
1583: );
1584: END IF;
1585:

Line 1610: wf_engine.itemstatus (itemtype => oe_globals.g_wfi_bkt,

1606:
1607: IF l_count > 0
1608: THEN
1609: -- Bug 8537639
1610: wf_engine.itemstatus (itemtype => oe_globals.g_wfi_bkt,
1611: itemkey => p_id,
1612: status => l_status,
1613: RESULT => l_result
1614: );

Line 1618: wf_engine.abortprocess (itemtype => oe_globals.g_wfi_bkt,

1614: );
1615:
1616: IF NVL (l_status, 'ACTIVE') <> 'COMPLETE'
1617: THEN
1618: wf_engine.abortprocess (itemtype => oe_globals.g_wfi_bkt,
1619: itemkey => p_id
1620: );
1621: END IF;
1622:

Line 2762: wf_engine.getactivityattrtext (itemtype, itemkey, actid,

2758: --
2759: IF (funcmode = 'RUN')
2760: THEN
2761: l_type :=
2762: wf_engine.getactivityattrtext (itemtype, itemkey, actid,
2763: 'SOURCE');
2764:
2765: IF l_type = 'PROFILE_APPROVER'
2766: THEN

Line 2864: wf_engine.setitemattrtext (itemtype,

2860: END IF;
2861: */
2862: END IF;
2863:
2864: wf_engine.setitemattrtext (itemtype,
2865: itemkey,
2866:
2867: -- Bug 9386150: provide a default value for 'v_value'
2868: 'NOTIFICATION_APPROVER',

Line 2959: wf_engine.getitemattrtext (p_item_type,

2955: THEN
2956: l_sales_document_type_code := 'B';
2957: ELSE -- itemtype = OENH
2958: l_sales_document_type_code :=
2959: wf_engine.getitemattrtext (p_item_type,
2960: p_item_key,
2961: 'SALES_DOCUMENT_TYPE_CODE'
2962: );
2963: END IF;

Line 3410: l_aname wf_engine.nametabtyp;

3406: )
3407: IS
3408: user_key_string VARCHAR2 (240);
3409: l_valid_process VARCHAR2 (30);
3410: l_aname wf_engine.nametabtyp;
3411: l_aname2 wf_engine.nametabtyp;
3412: l_avalue wf_engine.numtabtyp;
3413: l_avaluetext wf_engine.texttabtyp;
3414: l_user_name VARCHAR2 (100);

Line 3411: l_aname2 wf_engine.nametabtyp;

3407: IS
3408: user_key_string VARCHAR2 (240);
3409: l_valid_process VARCHAR2 (30);
3410: l_aname wf_engine.nametabtyp;
3411: l_aname2 wf_engine.nametabtyp;
3412: l_avalue wf_engine.numtabtyp;
3413: l_avaluetext wf_engine.texttabtyp;
3414: l_user_name VARCHAR2 (100);
3415: l_validate_user NUMBER;

Line 3412: l_avalue wf_engine.numtabtyp;

3408: user_key_string VARCHAR2 (240);
3409: l_valid_process VARCHAR2 (30);
3410: l_aname wf_engine.nametabtyp;
3411: l_aname2 wf_engine.nametabtyp;
3412: l_avalue wf_engine.numtabtyp;
3413: l_avaluetext wf_engine.texttabtyp;
3414: l_user_name VARCHAR2 (100);
3415: l_validate_user NUMBER;
3416: l_owner_role VARCHAR2 (100);

Line 3413: l_avaluetext wf_engine.texttabtyp;

3409: l_valid_process VARCHAR2 (30);
3410: l_aname wf_engine.nametabtyp;
3411: l_aname2 wf_engine.nametabtyp;
3412: l_avalue wf_engine.numtabtyp;
3413: l_avaluetext wf_engine.texttabtyp;
3414: l_user_name VARCHAR2 (100);
3415: l_validate_user NUMBER;
3416: l_owner_role VARCHAR2 (100);
3417: --

Line 3465: wf_engine.createprocess (p_item_type,

3461: FROM fnd_user
3462: WHERE user_id = p_user_id;
3463:
3464: -- Create process
3465: wf_engine.createprocess (p_item_type,
3466: p_item_key,
3467: p_process_name,
3468: user_key_string,
3469: l_owner_role

Line 3474: oe_debug_pub.ADD ('After WF_ENGINE.CreateProcess', 4);

3470: );
3471:
3472: IF l_debug_level > 0
3473: THEN
3474: oe_debug_pub.ADD ('After WF_ENGINE.CreateProcess', 4);
3475: END IF;
3476:
3477: -- Set various Header Attributes
3478: l_aname (1) := 'USER_ID';

Line 3488: wf_engine.setitemattrnumberarray (p_item_type,

3484: l_aname (4) := 'ORG_ID';
3485: l_avalue (4) := p_org_id;
3486: l_aname (5) := 'TRANSACTION_NUMBER';
3487: l_avalue (5) := p_transaction_number;
3488: wf_engine.setitemattrnumberarray (p_item_type,
3489: p_item_key,
3490: l_aname,
3491: l_avalue
3492: );

Line 3589: l_aname wf_engine.nametabtyp;

3585: p_sales_document_type_code IN VARCHAR2
3586: )
3587: IS
3588: l_hdr_process_name VARCHAR2 (30);
3589: l_aname wf_engine.nametabtyp;
3590: l_aname2 wf_engine.nametabtyp;
3591: l_avalue wf_engine.numtabtyp;
3592: l_avaluetext wf_engine.texttabtyp;
3593: user_key_string VARCHAR2 (240);

Line 3590: l_aname2 wf_engine.nametabtyp;

3586: )
3587: IS
3588: l_hdr_process_name VARCHAR2 (30);
3589: l_aname wf_engine.nametabtyp;
3590: l_aname2 wf_engine.nametabtyp;
3591: l_avalue wf_engine.numtabtyp;
3592: l_avaluetext wf_engine.texttabtyp;
3593: user_key_string VARCHAR2 (240);
3594: l_user_name VARCHAR2 (100);

Line 3591: l_avalue wf_engine.numtabtyp;

3587: IS
3588: l_hdr_process_name VARCHAR2 (30);
3589: l_aname wf_engine.nametabtyp;
3590: l_aname2 wf_engine.nametabtyp;
3591: l_avalue wf_engine.numtabtyp;
3592: l_avaluetext wf_engine.texttabtyp;
3593: user_key_string VARCHAR2 (240);
3594: l_user_name VARCHAR2 (100);
3595: l_validate_user NUMBER;

Line 3592: l_avaluetext wf_engine.texttabtyp;

3588: l_hdr_process_name VARCHAR2 (30);
3589: l_aname wf_engine.nametabtyp;
3590: l_aname2 wf_engine.nametabtyp;
3591: l_avalue wf_engine.numtabtyp;
3592: l_avaluetext wf_engine.texttabtyp;
3593: user_key_string VARCHAR2 (240);
3594: l_user_name VARCHAR2 (100);
3595: l_validate_user NUMBER;
3596: l_sales_document_type VARCHAR2 (240);

Line 3643: wf_engine.createprocess (p_item_type,

3639: FROM fnd_user
3640: WHERE user_id = fnd_global.user_id;
3641:
3642: -- Create Header Work item
3643: wf_engine.createprocess (p_item_type,
3644: TO_CHAR (p_header_id),
3645: l_hdr_process_name,
3646: user_key_string,
3647: l_owner_role

Line 3652: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');

3648: );
3649:
3650: IF l_debug_level > 0
3651: THEN
3652: oe_debug_pub.ADD ('AFTER WF_ENGINE.CREATEPROCESS');
3653: END IF;
3654:
3655: -- Set various Header Attributes
3656: l_aname (1) := 'USER_ID';

Line 3673: wf_engine.setitemattrnumberarray (p_item_type,

3669: l_aname (6) := 'HEADER_ID';
3670: l_avalue (6) := p_header_id;
3671: END IF;
3672:
3673: wf_engine.setitemattrnumberarray (p_item_type,
3674: TO_CHAR (p_header_id),
3675: l_aname,
3676: l_avalue
3677: );

Line 3691: wf_engine.setitemattrtext (p_item_type,

3687: THEN
3688: l_user_name := NULL; -- do not set FROM_ROLE then
3689: END;
3690:
3691: wf_engine.setitemattrtext (p_item_type,
3692: TO_CHAR (p_header_id),
3693: 'NOTIFICATION_FROM_ROLE',
3694: l_user_name
3695: );

Line 3708: wf_engine.setitemattrtextarray (p_item_type,

3704: l_avaluetext (2) := l_sales_document_type;
3705: -- CONTRACT_ATTACHMENT will not be set here, it may be too early, we need
3706: -- to call contract to determine the attachment, at a later time, it's done
3707: -- at Initiate_Approval
3708: wf_engine.setitemattrtextarray (p_item_type,
3709: TO_CHAR (p_header_id),
3710: l_aname2,
3711: l_avaluetext
3712: );

Line 3755: wf_engine.setitemuserkey (oe_globals.g_wfi_ngo, p_header_id, l_user_key);

3751: );
3752: END IF;
3753:
3754: l_user_key := SUBSTRB (fnd_message.get, 1, 240);
3755: wf_engine.setitemuserkey (oe_globals.g_wfi_ngo, p_header_id, l_user_key);
3756: EXCEPTION
3757: WHEN OTHERS
3758: THEN
3759: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)

Line 3777: wf_engine.setitemuserkey (oe_globals.g_wfi_bkt, p_header_id,

3773: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
3774: fnd_message.set_token ('BLANKET_NUMBER',
3775: TO_CHAR (p_transaction_number));
3776: l_user_key := SUBSTRB (fnd_message.get, 1, 240);
3777: wf_engine.setitemuserkey (oe_globals.g_wfi_bkt, p_header_id,
3778: l_user_key);
3779: EXCEPTION
3780: WHEN OTHERS
3781: THEN

Line 3841: wf_engine.getitemattrnumber (l_item_type,

3837:
3838: IF l_item_type = 'OEAME'
3839: THEN
3840: l_header_id :=
3841: wf_engine.getitemattrnumber (l_item_type,
3842: l_item_key,
3843: 'HEADER_ID'
3844: );
3845:

Line 3867: wf_engine.getitemattrtext (oe_globals.g_wfi_ngo,

3863: THEN
3864: l_blanket_flag := 'Y';
3865: ELSE
3866: l_sales_document_type_code :=
3867: wf_engine.getitemattrtext (oe_globals.g_wfi_ngo,
3868: l_header_id, -- ame er 16084377
3869: 'SALES_DOCUMENT_TYPE_CODE'
3870: );
3871:

Line 3921: l_aname wf_engine.nametabtyp;

3917: l_transaction_id NUMBER;
3918: --l_header_id NUMBER;
3919: l_blanket_flag VARCHAR2 (1);
3920: l_item_type VARCHAR2 (8);
3921: l_aname wf_engine.nametabtyp;
3922: l_avaluetext wf_engine.texttabtyp;
3923: l_transaction_number NUMBER;
3924: -- Blanket Header Attributes
3925: l_order_number NUMBER;

Line 3922: l_avaluetext wf_engine.texttabtyp;

3918: --l_header_id NUMBER;
3919: l_blanket_flag VARCHAR2 (1);
3920: l_item_type VARCHAR2 (8);
3921: l_aname wf_engine.nametabtyp;
3922: l_avaluetext wf_engine.texttabtyp;
3923: l_transaction_number NUMBER;
3924: -- Blanket Header Attributes
3925: l_order_number NUMBER;
3926: l_blanket_min_amount NUMBER;

Line 4126: wf_engine.getitemattrnumber (p_item_type,

4122: --------------------------------------------------
4123: IF l_wf_header_attr <> 'Y'
4124: THEN
4125: l_transaction_number :=
4126: wf_engine.getitemattrnumber (p_item_type,
4127: p_item_key,
4128: 'TRANSACTION_NUMBER'
4129: );
4130: l_salesrep :=

Line 4131: wf_engine.getitemattrtext (p_item_type,

4127: p_item_key,
4128: 'TRANSACTION_NUMBER'
4129: );
4130: l_salesrep :=
4131: wf_engine.getitemattrtext (p_item_type,
4132: p_item_key,
4133: 'SALESPERSON'
4134: );
4135: l_sold_to :=

Line 4136: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');

4132: p_item_key,
4133: 'SALESPERSON'
4134: );
4135: l_sold_to :=
4136: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');
4137: l_document :=
4138: l_document
4139: || ''
4140: || TO_CHAR (l_transaction_number)

Line 4205: wf_engine.getitemattrnumber (p_item_type,

4201: --- TEXT ---
4202: ELSIF p_display_type = 'text/plain'
4203: THEN
4204: l_transaction_number :=
4205: wf_engine.getitemattrnumber (p_item_type,
4206: p_item_key,
4207: 'TRANSACTION_NUMBER'
4208: );
4209: l_salesrep :=

Line 4210: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SALESPERSON');

4206: p_item_key,
4207: 'TRANSACTION_NUMBER'
4208: );
4209: l_salesrep :=
4210: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SALESPERSON');
4211: l_sold_to :=
4212: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');
4213: -- set fnd msg title
4214: l_msg_blanket_number :=

Line 4212: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');

4208: );
4209: l_salesrep :=
4210: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SALESPERSON');
4211: l_sold_to :=
4212: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');
4213: -- set fnd msg title
4214: l_msg_blanket_number :=
4215: fnd_message.get_string ('ONT', 'OE_NTF_BLANKET_NUMBER');
4216: l_msg_salesperson :=

Line 4297: l_aname wf_engine.nametabtyp;

4293: l_expiration_date DATE;
4294: l_transaction_id NUMBER;
4295: l_blanket_flag VARCHAR2 (1);
4296: l_item_type VARCHAR2 (8);
4297: l_aname wf_engine.nametabtyp;
4298: l_avaluetext wf_engine.texttabtyp;
4299: l_transaction_number NUMBER;
4300: -- Quote Header table attributes
4301: l_creation_date DATE;

Line 4298: l_avaluetext wf_engine.texttabtyp;

4294: l_transaction_id NUMBER;
4295: l_blanket_flag VARCHAR2 (1);
4296: l_item_type VARCHAR2 (8);
4297: l_aname wf_engine.nametabtyp;
4298: l_avaluetext wf_engine.texttabtyp;
4299: l_transaction_number NUMBER;
4300: -- Quote Header table attributes
4301: l_creation_date DATE;
4302: l_ship_to_address VARCHAR2 (40);

Line 4577: wf_engine.getitemattrnumber (p_item_type,

4573: --------------------------------------------------
4574: IF l_wf_header_attr <> 'Y'
4575: THEN
4576: l_transaction_number :=
4577: wf_engine.getitemattrnumber (p_item_type,
4578: p_item_key,
4579: 'TRANSACTION_NUMBER'
4580: );
4581: l_salesrep :=

Line 4582: wf_engine.getitemattrtext (p_item_type,

4578: p_item_key,
4579: 'TRANSACTION_NUMBER'
4580: );
4581: l_salesrep :=
4582: wf_engine.getitemattrtext (p_item_type,
4583: p_item_key,
4584: 'SALESPERSON'
4585: );
4586: l_sold_to :=

Line 4587: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');

4583: p_item_key,
4584: 'SALESPERSON'
4585: );
4586: l_sold_to :=
4587: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');
4588:
4589: BEGIN
4590: --Bug 12884612: Using to_date to convert from text to date correctly
4591: l_expiration_date :=

Line 4592: TO_DATE (wf_engine.getitemattrtext (p_item_type,

4588:
4589: BEGIN
4590: --Bug 12884612: Using to_date to convert from text to date correctly
4591: l_expiration_date :=
4592: TO_DATE (wf_engine.getitemattrtext (p_item_type,
4593: p_item_key,
4594: 'EXPIRATION_DATE'
4595: ),
4596: 'DD-MON-RRRR'

Line 4603: TO_DATE (wf_engine.getitemattrtext (p_item_type,

4599: WHEN OTHERS
4600: THEN
4601: -- to avoid regression for quotes already open at the time of 12884612 patch application
4602: l_expiration_date :=
4603: TO_DATE (wf_engine.getitemattrtext (p_item_type,
4604: p_item_key,
4605: 'EXPIRATION_DATE'
4606: )
4607: );

Line 4828: wf_engine.getitemattrnumber (p_item_type,

4824: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4825: l_msg_expiration_date :=
4826: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
4827: l_transaction_number :=
4828: wf_engine.getitemattrnumber (p_item_type,
4829: p_item_key,
4830: 'TRANSACTION_NUMBER'
4831: );
4832: l_salesrep :=

Line 4833: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SALESPERSON');

4829: p_item_key,
4830: 'TRANSACTION_NUMBER'
4831: );
4832: l_salesrep :=
4833: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SALESPERSON');
4834: l_sold_to :=
4835: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');
4836:
4837: BEGIN

Line 4835: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');

4831: );
4832: l_salesrep :=
4833: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SALESPERSON');
4834: l_sold_to :=
4835: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');
4836:
4837: BEGIN
4838: --Bug 12884612: Using to_date to convert from text to date correctly
4839: l_expiration_date :=

Line 4840: TO_DATE (wf_engine.getitemattrtext (p_item_type,

4836:
4837: BEGIN
4838: --Bug 12884612: Using to_date to convert from text to date correctly
4839: l_expiration_date :=
4840: TO_DATE (wf_engine.getitemattrtext (p_item_type,
4841: p_item_key,
4842: 'EXPIRATION_DATE'
4843: ),
4844: 'DD-MON-RRRR'

Line 4851: TO_DATE (wf_engine.getitemattrtext (p_item_type,

4847: WHEN OTHERS
4848: THEN
4849: -- to avoid regression for quotes already open at the time of 12884612 patch application
4850: l_expiration_date :=
4851: TO_DATE (wf_engine.getitemattrtext (p_item_type,
4852: p_item_key,
4853: 'EXPIRATION_DATE'
4854: )
4855: );

Line 5049: wf_engine.completeactivityinternalname (oe_globals.g_wfi_ngo,

5045: oe_debug_pub.ADD ('ELIGIBLE Activity: ' || l_activity);
5046: END IF;
5047:
5048: BEGIN
5049: wf_engine.completeactivityinternalname (oe_globals.g_wfi_ngo,
5050: TO_CHAR (p_header_id),
5051: l_activity,
5052: l_retval
5053: ,TRUE