DBA Data[Home] [Help]

APPS.IBE_QUOTE_SAVESHARE_V2_PVT dependencies on FND_GLOBAL

Line 27: where user_id = FND_GLOBAL.USER_ID;

23: rec_check_active_cart c_check_active_cart%rowtype;
24: cursor c_userenv_partyid is
25: select customer_id
26: from FND_USER
27: where user_id = FND_GLOBAL.USER_ID;
28: rec_userenv_partyid c_userenv_partyid%rowtype;
29:
30: /*This procedure is used to save the missing party_id and cust_account_id
31: of the recipient before cart activation*/

Line 666: IBE_UTIL.DEBUG('Save_recipients: FND_GLOBAL.USER_ID: '||FND_GLOBAL.USER_ID);

662: /*If there is an end-dated record present for the given combination of party, cust_account,
663: quote_hdr in quote_access then use this record, else insert a new record*/
664: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
665: IBE_UTIL.DEBUG('Save_recipients: Opening c_get_created_recip');
666: IBE_UTIL.DEBUG('Save_recipients: FND_GLOBAL.USER_ID: '||FND_GLOBAL.USER_ID);
667: END IF;
668: l_quote_access_rec.quote_sharee_id := FND_API.G_MISS_NUM;
669: FOR rec_get_created_recip in c_get_created_recip(p_quote_access_tbl(counter).quote_header_id,
670: p_quote_access_tbl(counter).party_id,

Line 671: FND_GLOBAL.USER_ID) LOOP

667: END IF;
668: l_quote_access_rec.quote_sharee_id := FND_API.G_MISS_NUM;
669: FOR rec_get_created_recip in c_get_created_recip(p_quote_access_tbl(counter).quote_header_id,
670: p_quote_access_tbl(counter).party_id,
671: FND_GLOBAL.USER_ID) LOOP
672: l_quote_access_rec.quote_sharee_id := rec_get_created_recip.quote_sharee_id;
673: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
674: IBE_UTIL.DEBUG('Save_recipients: rec_get_created_recip found quote_sharee_id: '||l_quote_access_rec.quote_sharee_id);
675: END IF;

Line 877: x_last_updated_by => fnd_global.user_id,

873: x_cust_account_id => l_quote_access_rec.cust_account_id,
874: X_RECORD_TYPE => 'CART',
875: X_CURRENCY_CODE => null,
876: x_last_update_date => sysdate,
877: x_last_updated_by => fnd_global.user_id,
878: x_last_update_login => 1);
879: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
880: IBE_UTIL.DEBUG('Done calling Update handler of active_quotes_all table to erase the quote header id' );
881: END IF;

Line 1285: x_last_updated_by => fnd_global.user_id,

1281:
1282: IBE_ACTIVE_QUOTES_ALL_PKG.update_row(
1283: X_OBJECT_VERSION_NUMBER => 1,
1284: x_last_update_date => sysdate,
1285: x_last_updated_by => fnd_global.user_id,
1286: x_last_update_login => 1,
1287: X_RECORD_TYPE => 'CART',
1288: X_CURRENCY_CODE => null,
1289: x_party_id => p_party_id,

Line 1310: X_CREATED_BY => fnd_global.USER_ID,

1306: X_LAST_UPDATE_DATE => sysdate,
1307: X_CREATION_DATE => sysdate,
1308: X_RECORD_TYPE => 'CART',
1309: X_CURRENCY_CODE => null,
1310: X_CREATED_BY => fnd_global.USER_ID,
1311: X_LAST_UPDATED_BY => fnd_global.USER_ID,
1312: X_LAST_UPDATE_LOGIN => fnd_global.conc_login_id,
1313: X_ORG_ID => MO_GLOBAL.get_current_org_id());
1314: END IF;

Line 1311: X_LAST_UPDATED_BY => fnd_global.USER_ID,

1307: X_CREATION_DATE => sysdate,
1308: X_RECORD_TYPE => 'CART',
1309: X_CURRENCY_CODE => null,
1310: X_CREATED_BY => fnd_global.USER_ID,
1311: X_LAST_UPDATED_BY => fnd_global.USER_ID,
1312: X_LAST_UPDATE_LOGIN => fnd_global.conc_login_id,
1313: X_ORG_ID => MO_GLOBAL.get_current_org_id());
1314: END IF;
1315:

Line 1312: X_LAST_UPDATE_LOGIN => fnd_global.conc_login_id,

1308: X_RECORD_TYPE => 'CART',
1309: X_CURRENCY_CODE => null,
1310: X_CREATED_BY => fnd_global.USER_ID,
1311: X_LAST_UPDATED_BY => fnd_global.USER_ID,
1312: X_LAST_UPDATE_LOGIN => fnd_global.conc_login_id,
1313: X_ORG_ID => MO_GLOBAL.get_current_org_id());
1314: END IF;
1315:
1316: if ((P_control_rec.pricing_request_type <> FND_API.G_MISS_CHAR) or

Line 1695: x_last_updated_by => fnd_global.user_id,

1691: X_CUST_ACCOUNT_ID => p_cust_account_id,
1692: X_RECORD_TYPE => 'CART',
1693: X_CURRENCY_CODE => null,
1694: x_last_update_date => sysdate,
1695: x_last_updated_by => fnd_global.user_id,
1696: x_last_update_login => 1);
1697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1698: IBE_UTIL.DEBUG('Done calling Update handler of active_quotes_all table to erase the quote header id' );
1699: END IF;

Line 2742: x_last_updated_by => fnd_global.user_id ,

2738: X_CUST_ACCOUNT_ID => rec_find_active_cart.cust_account_id,
2739: X_RECORD_TYPE => 'CART' ,
2740: X_CURRENCY_CODE => null ,
2741: x_last_update_date => sysdate ,
2742: x_last_updated_by => fnd_global.user_id ,
2743: x_last_update_login => 1);
2744: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2745: IBE_UTIL.DEBUG('Done calling update row handler to deactivate the cart');
2746: END IF;

Line 3090: l_env_user_id := FND_GLOBAL.USER_ID;

3086: END IF;
3087:
3088: ------------ VALIDATIONS ON THE INPUT QUOTE ACCESS TABLE ------------------------------
3089: if ((l_check_updates = FND_API.G_TRUE) or (l_check_onlynotify = FND_API.G_TRUE)) then
3090: l_env_user_id := FND_GLOBAL.USER_ID;
3091: FOR i in 1..p_quote_access_tbl.count LOOP
3092: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3093: IBE_UTIL.DEBUG('current quote_sharee_id : '||p_quote_access_tbl(i).quote_sharee_id);
3094: end if;