DBA Data[Home] [Help]

APPS.POS_REG_WF_PKG dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 521: lv_registration_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

517: ln_reg_id NUMBER := -1;
518: ln_app_id NUMBER := -1;
519: lv_reg_type FND_REGISTRATIONS.REGISTRATION_TYPE%TYPE := NULL;
520:
521: lv_registration_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
522: lv_proc_name VARCHAR2(30) := 'UpdItemTypeKeyHelper';
523:
524: BEGIN
525:

Line 591: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

587: , resultout OUT NOCOPY VARCHAR2
588: )
589: IS
590:
591: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
592: lv_reg_status FND_REGISTRATIONS.REGISTRATION_STATUS%TYPE;
593: lv_proc_name VARCHAR2(30) := 'LockReg';
594:
595: BEGIN

Line 691: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

687: , resultout OUT NOCOPY VARCHAR2
688: )
689: IS
690:
691: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
692: lv_reg_status FND_REGISTRATIONS.REGISTRATION_STATUS%TYPE;
693: lv_proc_name VARCHAR2(30) := 'LockApprv';
694:
695: BEGIN

Line 1080: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

1076: , resultout OUT NOCOPY VARCHAR2
1077: )
1078: IS
1079:
1080: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1081: ln_reg_id NUMBER;
1082:
1083: lv_registrant_lang FND_REGISTRATIONS.LANGUAGE_CODE%TYPE;
1084: lv_registrant_email FND_REGISTRATIONS.EMAIL%TYPE;

Line 1236: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

1232: , resultout OUT NOCOPY VARCHAR2
1233: )
1234: IS
1235:
1236: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1237: ln_reg_id NUMBER;
1238:
1239: lv_first_name FND_REGISTRATIONS.FIRST_NAME%TYPE := NULL;
1240: lv_last_name FND_REGISTRATIONS.LAST_NAME%TYPE := NULL;

Line 1499: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

1495: , resultout OUT NOCOPY VARCHAR2
1496: )
1497: IS
1498:
1499: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1500: ln_reg_id NUMBER;
1501:
1502: lv_requested_user_name FND_REGISTRATIONS.REQUESTED_USER_NAME%TYPE := NULL;
1503: lv_user_email FND_REGISTRATIONS.EMAIL%TYPE := NULL;

Line 1813: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

1809: , resultout OUT NOCOPY VARCHAR2
1810: )
1811: IS
1812:
1813: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
1814: ln_reg_id NUMBER;
1815:
1816: lv_registrant_lang FND_REGISTRATIONS.LANGUAGE_CODE%TYPE;
1817: lv_registrant_email FND_REGISTRATIONS.EMAIL%TYPE;

Line 2658: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

2654: , resultout OUT NOCOPY VARCHAR2
2655: )
2656: IS
2657:
2658: lv_reg_key WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2659: ln_reg_id NUMBER := -1;
2660:
2661: -- user info needed to update FND_USER and TCA
2662:

Line 2673: lv_user_firstname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

2669:
2670: lv_user_description FND_USER.DESCRIPTION%TYPE;
2671: lv_user_email FND_USER.EMAIL_ADDRESS%TYPE;
2672: ln_vendor_id NUMBER;
2673: lv_user_firstname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2674: lv_user_lastname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2675: lv_user_middlename WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2676: lv_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2677: lv_phone WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

Line 2674: lv_user_lastname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

2670: lv_user_description FND_USER.DESCRIPTION%TYPE;
2671: lv_user_email FND_USER.EMAIL_ADDRESS%TYPE;
2672: ln_vendor_id NUMBER;
2673: lv_user_firstname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2674: lv_user_lastname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2675: lv_user_middlename WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2676: lv_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2677: lv_phone WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2678: lv_phone_ext WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

Line 2675: lv_user_middlename WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

2671: lv_user_email FND_USER.EMAIL_ADDRESS%TYPE;
2672: ln_vendor_id NUMBER;
2673: lv_user_firstname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2674: lv_user_lastname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2675: lv_user_middlename WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2676: lv_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2677: lv_phone WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2678: lv_phone_ext WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2679: lv_fax WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

Line 2676: lv_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

2672: ln_vendor_id NUMBER;
2673: lv_user_firstname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2674: lv_user_lastname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2675: lv_user_middlename WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2676: lv_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2677: lv_phone WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2678: lv_phone_ext WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2679: lv_fax WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2680: lv_job_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

Line 2677: lv_phone WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

2673: lv_user_firstname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2674: lv_user_lastname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2675: lv_user_middlename WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2676: lv_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2677: lv_phone WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2678: lv_phone_ext WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2679: lv_fax WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2680: lv_job_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2681:

Line 2678: lv_phone_ext WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

2674: lv_user_lastname WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2675: lv_user_middlename WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2676: lv_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2677: lv_phone WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2678: lv_phone_ext WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2679: lv_fax WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2680: lv_job_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2681:
2682: ln_user_fnd_id NUMBER := -1;

Line 2679: lv_fax WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

2675: lv_user_middlename WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2676: lv_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2677: lv_phone WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2678: lv_phone_ext WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2679: lv_fax WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2680: lv_job_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2681:
2682: ln_user_fnd_id NUMBER := -1;
2683: ln_pon_app_id NUMBER := -1;

Line 2680: lv_job_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;

2676: lv_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2677: lv_phone WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2678: lv_phone_ext WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2679: lv_fax WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2680: lv_job_title WF_ITEM_ATTRIBUTE_VALUES.TEXT_VALUE%TYPE;
2681:
2682: ln_user_fnd_id NUMBER := -1;
2683: ln_pon_app_id NUMBER := -1;
2684: ln_pos_app_id NUMBER := -1;