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.EGO_ITEM_PVT dependencies on EGO_ITEM_PUB

Line 346: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE

342: ) RETURN BOOLEAN IS
343: l_hz_party_type HZ_PARTIES.party_type%TYPE;
344: l_dummy_char VARCHAR2(32767);
345: BEGIN
346: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE
347: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
348: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
349: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
350: ) THEN

Line 347: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE

343: l_hz_party_type HZ_PARTIES.party_type%TYPE;
344: l_dummy_char VARCHAR2(32767);
345: BEGIN
346: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE
347: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
348: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
349: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
350: ) THEN
351: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN

Line 348: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE

344: l_dummy_char VARCHAR2(32767);
345: BEGIN
346: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE
347: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
348: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
349: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
350: ) THEN
351: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
352: x_party_id := -1000; -- needed by EGO_SECURITY_PUB

Line 349: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE

345: BEGIN
346: IF p_party_type IN (EGO_ITEM_PUB.G_USER_PARTY_TYPE
347: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
348: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
349: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
350: ) THEN
351: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
352: x_party_id := -1000; -- needed by EGO_SECURITY_PUB
353: x_party_name := p_party_type;

Line 351: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN

347: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
348: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
349: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
350: ) THEN
351: IF p_party_type = EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE THEN
352: x_party_id := -1000; -- needed by EGO_SECURITY_PUB
353: x_party_name := p_party_type;
354: RETURN TRUE;
355: ELSE

Line 356: IF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN

352: x_party_id := -1000; -- needed by EGO_SECURITY_PUB
353: x_party_name := p_party_type;
354: RETURN TRUE;
355: ELSE
356: IF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
357: l_hz_party_type := G_HZ_COMPANY_PARTY_TYPE;
358: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
359: l_hz_party_type := p_party_type;
360: ELSIF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN

Line 358: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN

354: RETURN TRUE;
355: ELSE
356: IF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
357: l_hz_party_type := G_HZ_COMPANY_PARTY_TYPE;
358: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
359: l_hz_party_type := p_party_type;
360: ELSIF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
361: l_hz_party_type := G_HZ_USER_PARTY_TYPE;
362: END IF;

Line 360: ELSIF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN

356: IF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
357: l_hz_party_type := G_HZ_COMPANY_PARTY_TYPE;
358: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
359: l_hz_party_type := p_party_type;
360: ELSIF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
361: l_hz_party_type := G_HZ_USER_PARTY_TYPE;
362: END IF;
363: IF x_party_id IS NOT NULL THEN
364: -- validate the party_id passed.

Line 821: G_Item_Rec EGO_Item_PUB.Item_Rec_Type;

817: l_error_code NUMBER;
818: --R12 C
819: l_return_err VARCHAR2(1000);
820: l_batch_id NUMBER;
821: G_Item_Rec EGO_Item_PUB.Item_Rec_Type;
822: -- added for bug 7431714
823: l_icc_change_flag BOOLEAN := FALSE;
824: l_init_msg_list VARCHAR2(1) := NULL;
825: l_curr_icc_id NUMBER;

Line 1709: EGO_ITEM_PUB.Update_Item_Attr_Ext(

1705: END IF;
1706: --End 4105841 : Business Event Enhancement
1707: --- added for bug 7431714
1708: IF (l_icc_change_flag) THEN
1709: EGO_ITEM_PUB.Update_Item_Attr_Ext(
1710: P_API_VERSION => 1.0,
1711: P_INIT_MSG_LIST => l_init_msg_list,
1712: P_COMMIT => P_COMMIT,
1713: P_INVENTORY_ITEM_ID => l_Item_rec_in.INVENTORY_ITEM_ID,

Line 1811: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;

1807:
1808: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Org_Assignments';
1809: l_return_status VARCHAR2(1) := G_MISS_CHAR;
1810: l_msg_count NUMBER := 0;
1811: l_Item_Org_Assignment_Rec EGO_Item_PUB.Item_Org_Assignment_Rec_Type;
1812: l_Item_rec_in INV_ITEM_GRP.Item_Rec_Type;
1813: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
1814: l_rev_index_failure BOOLEAN := FALSE;
1815: l_Item_rec_out INV_ITEM_GRP.Item_Rec_Type;

Line 3245: (EGO_ITEM_PUB.G_TTYPE_CREATE

3241: --
3242: IF ( p_transaction_type IS NULL
3243: OR
3244: p_transaction_type NOT IN
3245: (EGO_ITEM_PUB.G_TTYPE_CREATE
3246: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3247: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
3248: )
3249: OR

Line 3246: ,EGO_ITEM_PUB.G_TTYPE_DELETE

3242: IF ( p_transaction_type IS NULL
3243: OR
3244: p_transaction_type NOT IN
3245: (EGO_ITEM_PUB.G_TTYPE_CREATE
3246: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3247: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
3248: )
3249: OR
3250: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE

Line 3247: ,EGO_ITEM_PUB.G_TTYPE_UPDATE

3243: OR
3244: p_transaction_type NOT IN
3245: (EGO_ITEM_PUB.G_TTYPE_CREATE
3246: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3247: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
3248: )
3249: OR
3250: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
3251: AND( (p_role_name IS NULL AND p_role_id IS NULL)

Line 3250: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE

3246: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3247: ,EGO_ITEM_PUB.G_TTYPE_UPDATE
3248: )
3249: OR
3250: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
3251: AND( (p_role_name IS NULL AND p_role_id IS NULL)
3252: OR
3253: p_party_type IS NULL
3254: OR

Line 3256: (EGO_ITEM_PUB.G_USER_PARTY_TYPE

3252: OR
3253: p_party_type IS NULL
3254: OR
3255: p_party_type NOT IN
3256: (EGO_ITEM_PUB.G_USER_PARTY_TYPE
3257: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3258: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3259: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3260: )

Line 3257: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE

3253: p_party_type IS NULL
3254: OR
3255: p_party_type NOT IN
3256: (EGO_ITEM_PUB.G_USER_PARTY_TYPE
3257: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3258: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3259: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3260: )
3261: OR

Line 3258: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE

3254: OR
3255: p_party_type NOT IN
3256: (EGO_ITEM_PUB.G_USER_PARTY_TYPE
3257: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3258: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3259: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3260: )
3261: OR
3262: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE

Line 3259: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE

3255: p_party_type NOT IN
3256: (EGO_ITEM_PUB.G_USER_PARTY_TYPE
3257: ,EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3258: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3259: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3260: )
3261: OR
3262: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3263: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE

Line 3262: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE

3258: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3259: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3260: )
3261: OR
3262: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3263: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3264: ,EGO_ITEM_PUB.G_USER_PARTY_TYPE)
3265: AND p_party_name IS NULL
3266: AND p_party_id IS NULL

Line 3263: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE

3259: ,EGO_ITEM_PUB.G_ALL_USERS_PARTY_TYPE
3260: )
3261: OR
3262: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3263: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3264: ,EGO_ITEM_PUB.G_USER_PARTY_TYPE)
3265: AND p_party_name IS NULL
3266: AND p_party_id IS NULL
3267: )

Line 3264: ,EGO_ITEM_PUB.G_USER_PARTY_TYPE)

3260: )
3261: OR
3262: (p_party_type IN (EGO_ITEM_PUB.G_GROUP_PARTY_TYPE
3263: ,EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE
3264: ,EGO_ITEM_PUB.G_USER_PARTY_TYPE)
3265: AND p_party_name IS NULL
3266: AND p_party_id IS NULL
3267: )
3268: OR

Line 3272: (EGO_ITEM_PUB.G_INSTANCE_TYPE_SET

3268: OR
3269: p_instance_type IS NULL
3270: OR
3271: p_instance_type NOT IN
3272: (EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3273: ,EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
3274: )
3275: OR
3276: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_SET

Line 3273: ,EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE

3269: p_instance_type IS NULL
3270: OR
3271: p_instance_type NOT IN
3272: (EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3273: ,EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
3274: )
3275: OR
3276: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3277: AND

Line 3276: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_SET

3272: (EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3273: ,EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
3274: )
3275: OR
3276: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_SET
3277: AND
3278: ( (p_instance_set_id IS NULL AND p_instance_set_name IS NULL)
3279: OR
3280: p_inventory_item_id IS NOT NULL

Line 3286: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE

3282: p_organization_id IS NOT NULL
3283: )
3284: )
3285: OR
3286: (p_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE
3287: AND
3288: ( (p_inventory_item_id IS NULL AND p_item_number IS NULL)
3289: OR
3290: (p_organization_id IS NULL AND p_organization_code IS NULL)

Line 3298: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

3294: )
3295: )
3296: )
3297: OR
3298: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
3299: AND (x_grant_guid IS NULL)
3300: )
3301: OR
3302: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE

Line 3302: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE

3298: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
3299: AND (x_grant_guid IS NULL)
3300: )
3301: OR
3302: (p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE
3303: AND (x_grant_guid IS NULL)
3304: )
3305: ) THEN
3306: --

Line 3328: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_DELETE

3324: l_party_id := p_party_id;
3325: l_party_name := p_party_name;
3326: l_create_grant_flag := TRUE;
3327:
3328: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_DELETE
3329: ,EGO_ITEM_PUB.G_TTYPE_UPDATE) THEN
3330:
3331: BEGIN
3332: SELECT instance_type, instance_set_id, instance_pk1_value,

Line 3329: ,EGO_ITEM_PUB.G_TTYPE_UPDATE) THEN

3325: l_party_name := p_party_name;
3326: l_create_grant_flag := TRUE;
3327:
3328: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_DELETE
3329: ,EGO_ITEM_PUB.G_TTYPE_UPDATE) THEN
3330:
3331: BEGIN
3332: SELECT instance_type, instance_set_id, instance_pk1_value,
3333: instance_pk2_value, start_date, end_date

Line 3343: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN

3339: code_debug(l_api_name||' grant validation check done ' );
3340: EXCEPTION
3341: WHEN NO_DATA_FOUND THEN
3342: code_debug (l_api_version ||' no grant found for modification ');
3343: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3344: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_UPDATE');
3345: ELSE
3346: fnd_message.set_name (G_APP_NAME, 'EGO_NO_REC_DELETE');
3347: END IF;

Line 3355: IF l_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE THEN

3351: --
3352: -- no security check done for the update of grants of type instance set.
3353: -- should this be done??
3354: --
3355: IF l_instance_type = EGO_ITEM_PUB.G_INSTANCE_TYPE_INSTANCE THEN
3356: l_inventory_item_id := l_pk1_value;
3357: l_organization_id := l_pk2_value;
3358: -- 4052565
3359: -- modified call to has_role_on_item from validate_role_privilege

Line 3384: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE THEN

3380: END IF;
3381: code_debug(l_api_name ||' user has function privilege to update the roles in instance set');
3382: END IF;
3383:
3384: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DELETE THEN
3385: --
3386: -- delete the grant given
3387: --
3388: code_debug(l_api_name||' calling EGO_SECURITY_PUB.revoke_grant ' );

Line 3408: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN

3404: COMMIT WORK;
3405: END IF;
3406: RETURN;
3407: END IF;
3408: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3409: --
3410: -- update the grant given
3411: --
3412: IF date_check (p_start_date => l_sysdate

Line 3457: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN

3453: END IF;
3454: RETURN;
3455: END IF;
3456: END IF;
3457: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE THEN
3458: code_debug(l_api_name||' started validations for CREATE ');
3459: --
3460: -- start validations for create
3461: --

Line 3471: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN

3467: ,x_party_name => l_party_name
3468: ) THEN
3469: code_debug (l_api_version ||' invalid party passed ');
3470: l_create_grant_flag := FALSE;
3471: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3472: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3473: l_dummy_char := fnd_message.get();
3474: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');

Line 3474: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN

3470: l_create_grant_flag := FALSE;
3471: IF p_party_type = EGO_ITEM_PUB.G_USER_PARTY_TYPE THEN
3472: fnd_message.Set_Name(G_APP_NAME, 'EGO_USER');
3473: l_dummy_char := fnd_message.get();
3474: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3476: l_dummy_char := fnd_message.get();
3477: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3478: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');

Line 3477: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN

3473: l_dummy_char := fnd_message.get();
3474: ELSIF p_party_type = EGO_ITEM_PUB.G_GROUP_PARTY_TYPE THEN
3475: fnd_message.Set_Name(G_APP_NAME, 'EGO_GROUP_NAME');
3476: l_dummy_char := fnd_message.get();
3477: ELSIF p_party_type = EGO_ITEM_PUB.G_COMPANY_PARTY_TYPE THEN
3478: fnd_message.Set_Name(G_APP_NAME, 'EGO_COMPANY');
3479: l_dummy_char := fnd_message.get();
3480: END IF;
3481: fnd_message.Set_Name(G_APP_NAME, 'EGO_IPI_INVALID_VALUE');

Line 3841: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE

3837: -- check for invalid params
3838: --
3839: IF ( p_transaction_type IS NULL
3840: OR
3841: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
3842: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3843: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
3844: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3845: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS

Line 3842: ,EGO_ITEM_PUB.G_TTYPE_DELETE

3838: --
3839: IF ( p_transaction_type IS NULL
3840: OR
3841: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
3842: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3843: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
3844: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3845: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
3846: )

Line 3843: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE

3839: IF ( p_transaction_type IS NULL
3840: OR
3841: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
3842: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3843: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
3844: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3845: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
3846: )
3847: OR

Line 3844: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE

3840: OR
3841: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
3842: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3843: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
3844: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3845: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
3846: )
3847: OR
3848: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE

Line 3845: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS

3841: p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
3842: ,EGO_ITEM_PUB.G_TTYPE_DELETE
3843: ,EGO_ITEM_PUB.G_TTYPE_PROMOTE
3844: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3845: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
3846: )
3847: OR
3848: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
3849: ,EGO_ITEM_PUB.G_TTYPE_DELETE)

Line 3848: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE

3844: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3845: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
3846: )
3847: OR
3848: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
3849: ,EGO_ITEM_PUB.G_TTYPE_DELETE)
3850: AND
3851: (p_revision IS NOT NULL OR p_revision_id IS NOT NULL)
3852: AND

Line 3849: ,EGO_ITEM_PUB.G_TTYPE_DELETE)

3845: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS
3846: )
3847: OR
3848: ( p_transaction_type NOT IN (EGO_ITEM_PUB.G_TTYPE_UPDATE
3849: ,EGO_ITEM_PUB.G_TTYPE_DELETE)
3850: AND
3851: (p_revision IS NOT NULL OR p_revision_id IS NOT NULL)
3852: AND
3853: p_status IS NOT NULL

Line 3876: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN

3872: l_inventory_item_id := p_inventory_item_id;
3873: l_item_number := p_item_number;
3874: l_sysdate := SYSDATE;
3875:
3876: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3877: l_effective_date := NVL(p_new_effective_date,l_sysdate);
3878: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE
3879: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3880: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN

Line 3878: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE

3874: l_sysdate := SYSDATE;
3875:
3876: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3877: l_effective_date := NVL(p_new_effective_date,l_sysdate);
3878: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE
3879: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3880: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN
3881: l_effective_date := NVL(p_effective_date, l_sysdate);
3882: ELSE

Line 3879: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE

3875:
3876: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3877: l_effective_date := NVL(p_new_effective_date,l_sysdate);
3878: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE
3879: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3880: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN
3881: l_effective_date := NVL(p_effective_date, l_sysdate);
3882: ELSE
3883: l_effective_date := l_sysdate;

Line 3880: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN

3876: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE THEN
3877: l_effective_date := NVL(p_new_effective_date,l_sysdate);
3878: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE
3879: ,EGO_ITEM_PUB.G_TTYPE_DEMOTE
3880: ,EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS) THEN
3881: l_effective_date := NVL(p_effective_date, l_sysdate);
3882: ELSE
3883: l_effective_date := l_sysdate;
3884: END IF;

Line 3932: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN

3928: l_change_status_flag := FALSE;
3929: fnd_message.Set_Name(G_APP_NAME, 'EGO_ITEM_NOT_APPROVED');
3930: fnd_msg_pub.Add;
3931: ELSE
3932: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
3933: l_priv_function_name := G_FN_NAME_PROMOTE;
3934: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN
3935: l_priv_function_name := G_FN_NAME_DEMOTE;
3936: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN

Line 3934: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN

3930: fnd_msg_pub.Add;
3931: ELSE
3932: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
3933: l_priv_function_name := G_FN_NAME_PROMOTE;
3934: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN
3935: l_priv_function_name := G_FN_NAME_DEMOTE;
3936: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN
3937: l_priv_function_name := G_FN_NAME_CHANGE_STATUS;
3938: END IF;

Line 3936: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN

3932: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
3933: l_priv_function_name := G_FN_NAME_PROMOTE;
3934: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN
3935: l_priv_function_name := G_FN_NAME_DEMOTE;
3936: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN
3937: l_priv_function_name := G_FN_NAME_CHANGE_STATUS;
3938: END IF;
3939: IF NOT has_role_on_item
3940: (p_function_name => l_priv_function_name

Line 3990: IF ( p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE)

3986: );
3987: FETCH c_get_item_det INTO l_curr_cc_id, l_curr_lifecycle_id, l_curr_phase_id, l_curr_status;
3988: CLOSE c_get_item_det;
3989: END IF;
3990: IF ( p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE)
3991: AND
3992: l_curr_lifecycle_id IS NULL
3993: ) THEN
3994: l_change_status_flag := FALSE;

Line 4015: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE) THEN

4011: --
4012: RAISE FND_API.G_EXC_ERROR;
4013: END IF;
4014:
4015: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE) THEN
4016: --
4017: -- check if there is a project associated
4018: --
4019: IF 'TRUE' = EGO_LIFECYCLE_USER_PUB.Has_LC_Tracking_Project

Line 4036: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN

4032: fnd_message.set_token('ORG_NAME', l_org_name);
4033: fnd_msg_pub.Add;
4034: END IF;
4035:
4036: IF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_PROMOTE THEN
4037: OPEN c_get_next_phase (cp_lifecycle_id => l_curr_lifecycle_id
4038: ,cp_phase_id => l_curr_phase_id
4039: );
4040: FETCH c_get_next_phase INTO l_future_phase_id, l_phase_sequence;

Line 4056: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN

4052: fnd_msg_pub.Add;
4053: ELSE
4054: CLOSE c_get_next_phase;
4055: END IF;
4056: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_DEMOTE THEN
4057: OPEN c_get_priv_phase (cp_lifecycle_id => l_curr_lifecycle_id
4058: ,cp_phase_id => l_curr_phase_id
4059: );
4060: FETCH c_get_priv_phase INTO l_future_phase_id, l_phase_sequence;

Line 4152: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN

4148: );
4149: fnd_message.set_token('CATALOG_CATEGORY_NAME', l_dummy_char);
4150: fnd_msg_pub.Add;
4151: END IF;
4152: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN
4153: -- check if the user has privilege to update the item.
4154: IF p_phase_id IS NOT NULL THEN
4155: -- user changing phase
4156: OPEN c_get_phase_seq(cp_phase_id => l_curr_phase_id);

Line 4201: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE) THEN

4197: END IF;
4198:
4199: IF l_change_status_flag THEN
4200: code_debug (l_api_name ||' calling EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change ');
4201: IF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_PROMOTE, EGO_ITEM_PUB.G_TTYPE_DEMOTE) THEN
4202: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4203: (p_api_version => p_api_version
4204: ,p_commit => FND_API.G_FALSE
4205: ,p_inventory_item_id => l_inventory_item_id

Line 4222: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN

4218: ,x_errorcode => l_dummy_char
4219: ,x_msg_count => x_msg_count
4220: ,x_msg_data => x_msg_data
4221: );
4222: ELSIF p_transaction_type = EGO_ITEM_PUB.G_TTYPE_CHANGE_STATUS THEN
4223: EGO_ITEM_LC_IMP_PC_PUB.Create_Pending_Phase_Change
4224: (p_api_version => p_api_version
4225: ,p_commit => FND_API.G_FALSE
4226: ,p_inventory_item_id => l_inventory_item_id

Line 4243: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN

4239: ,x_errorcode => l_dummy_char
4240: ,x_msg_count => x_msg_count
4241: ,x_msg_data => x_msg_data
4242: );
4243: ELSIF p_transaction_type IN (EGO_ITEM_PUB.G_TTYPE_UPDATE, EGO_ITEM_PUB.G_TTYPE_DELETE) THEN
4244: EGO_ITEM_LC_IMP_PC_PUB.Modify_Pending_Phase_Change
4245: (p_api_version => p_api_version
4246: ,p_commit => FND_API.G_FALSE
4247: ,p_transaction_type => p_transaction_type