DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on FND_GLOBAL

Line 16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

12: -- NOTE :
13: -- End of Comments
14:
15:
16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
18: G_PKG_NAME CONSTANT VARCHAR2 ( 30 ) := 'ASO_COPY_QUOTE_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2 ( 12 ) := 'asovcpyb.pls';
20:

Line 17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

13: -- End of Comments
14:
15:
16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
18: G_PKG_NAME CONSTANT VARCHAR2 ( 30 ) := 'ASO_COPY_QUOTE_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2 ( 12 ) := 'asovcpyb.pls';
20:
21:

Line 100: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

96: l_qte_header_id NUMBER;
97: l_qte_status_id NUMBER;
98: l_dummy VARCHAR2 ( 2 );
99: lx_Price_Index_Link_Tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
100: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
101: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
102: X_New_Qte_Line_Id NUMBER;
103: -- hyang: for bug 2692785
104: lx_status VARCHAR2(1);

Line 101: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

97: l_qte_status_id NUMBER;
98: l_dummy VARCHAR2 ( 2 );
99: lx_Price_Index_Link_Tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
100: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
101: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
102: X_New_Qte_Line_Id NUMBER;
103: -- hyang: for bug 2692785
104: lx_status VARCHAR2(1);
105: l_copy_line_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 194: IF FND_GLOBAL.User_Id IS NULL THEN

190: --
191: -- ******************************************************************
192: -- Validate Environment
193: -- ******************************************************************
194: IF FND_GLOBAL.User_Id IS NULL THEN
195: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
196: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
197: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
198: FND_MSG_PUB.ADD;

Line 791: p_last_updated_by => FND_Global.USER_ID ,

787: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
788: x_return_status => x_return_status ,
789: p_jtf_note_id => l_note_id ,
790: p_last_update_date => sysdate ,
791: p_last_updated_by => FND_Global.USER_ID ,
792: p_creation_date => sysdate ,
793: p_created_by => FND_Global.USER_ID ,
794: p_last_update_login => FND_GLOBAL.LOGIN_ID ,
795: p_note_context_type_id => x_qte_header_id ,

Line 793: p_created_by => FND_Global.USER_ID ,

789: p_jtf_note_id => l_note_id ,
790: p_last_update_date => sysdate ,
791: p_last_updated_by => FND_Global.USER_ID ,
792: p_creation_date => sysdate ,
793: p_created_by => FND_Global.USER_ID ,
794: p_last_update_login => FND_GLOBAL.LOGIN_ID ,
795: p_note_context_type_id => x_qte_header_id ,
796: p_note_context_type => 'ASO_QUOTE' ,
797: x_note_context_id => lx_jtf_note_context_id

Line 794: p_last_update_login => FND_GLOBAL.LOGIN_ID ,

790: p_last_update_date => sysdate ,
791: p_last_updated_by => FND_Global.USER_ID ,
792: p_creation_date => sysdate ,
793: p_created_by => FND_Global.USER_ID ,
794: p_last_update_login => FND_GLOBAL.LOGIN_ID ,
795: p_note_context_type_id => x_qte_header_id ,
796: p_note_context_type => 'ASO_QUOTE' ,
797: x_note_context_id => lx_jtf_note_context_id
798: );

Line 1371: || FND_GLOBAL.local_chr ( 45 )

1367: , p_new_object_id => x_qte_header_id
1368: , p_old_object_type_code => 'ASO_QUOTE'
1369: , p_new_object_type_code => 'ASO_QUOTE'
1370: , p_new_object_name => l_qte_header_rec.quote_number
1371: || FND_GLOBAL.local_chr ( 45 )
1372: || l_qte_header_rec.quote_version ,
1373: p_quote_version_flag => P_Copy_Quote_Control_Rec.New_Version
1374: );
1375: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1700: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1696: l_service_item_flag VARCHAR2 ( 1 );
1697: l_serviceable_product_flag VARCHAR2 ( 1 );
1698: l_return_status VARCHAR2 ( 1 );
1699: l_api_version_number CONSTANT NUMBER := 1.0;
1700: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1701: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1702: l_ship_id NUMBER;
1703: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
1704: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;

Line 1701: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1697: l_serviceable_product_flag VARCHAR2 ( 1 );
1698: l_return_status VARCHAR2 ( 1 );
1699: l_api_version_number CONSTANT NUMBER := 1.0;
1700: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
1701: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1702: l_ship_id NUMBER;
1703: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
1704: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
1705: -- hyang: for bug 2692785

Line 4000: , P_created_by => FND_GLOBAL.USER_ID

3996: l_new_template_instance_id := NULL;
3997: ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (
3998: PX_ROWID => l_template_instance_rowid
3999: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
4000: , P_created_by => FND_GLOBAL.USER_ID
4001: , P_creation_date => SYSDATE
4002: , P_last_updated_by => FND_GLOBAL.USER_ID
4003: , P_last_update_date => SYSDATE
4004: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

Line 4002: , P_last_updated_by => FND_GLOBAL.USER_ID

3998: PX_ROWID => l_template_instance_rowid
3999: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
4000: , P_created_by => FND_GLOBAL.USER_ID
4001: , P_creation_date => SYSDATE
4002: , P_last_updated_by => FND_GLOBAL.USER_ID
4003: , P_last_update_date => SYSDATE
4004: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
4005: , P_TEMPLATE_ID => template_val.template_id
4006: , P_Owner_Table_Name => 'ASO_QUOTE_HEADERS'

Line 4004: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

4000: , P_created_by => FND_GLOBAL.USER_ID
4001: , P_creation_date => SYSDATE
4002: , P_last_updated_by => FND_GLOBAL.USER_ID
4003: , P_last_update_date => SYSDATE
4004: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
4005: , P_TEMPLATE_ID => template_val.template_id
4006: , P_Owner_Table_Name => 'ASO_QUOTE_HEADERS'
4007: , P_Owner_Table_Id => p_new_quote_header_id
4008: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 4041: , P_created_by => FND_GLOBAL.USER_ID

4037: , P_Template_Instance_ID => l_new_template_instance_id
4038: , p_value => inst_val.VALUE
4039: , p_value_type_qualifier => inst_val.value_type_qualifier
4040: , p_response_id => inst_val.response_id
4041: , P_created_by => FND_GLOBAL.USER_ID
4042: , P_last_updated_by => FND_GLOBAL.USER_ID
4043: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
4044: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
4045: );

Line 4042: , P_last_updated_by => FND_GLOBAL.USER_ID

4038: , p_value => inst_val.VALUE
4039: , p_value_type_qualifier => inst_val.value_type_qualifier
4040: , p_response_id => inst_val.response_id
4041: , P_created_by => FND_GLOBAL.USER_ID
4042: , P_last_updated_by => FND_GLOBAL.USER_ID
4043: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
4044: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
4045: );
4046: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 4043: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

4039: , p_value_type_qualifier => inst_val.value_type_qualifier
4040: , p_response_id => inst_val.response_id
4041: , P_created_by => FND_GLOBAL.USER_ID
4042: , P_last_updated_by => FND_GLOBAL.USER_ID
4043: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
4044: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
4045: );
4046: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4047: aso_debug_pub.ADD ( 'New Instance Value Id : ' || TO_CHAR ( l_instance_value_id ) , 1 , 'N' );

Line 4333: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

4329: := ASO_CFG_INT.G_MISS_Control_Rec;
4330: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
4331: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4332: LX_LINE_RELATIONSHIP_ID NUMBER;
4333: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
4334: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
4335: l_ship_id NUMBER;
4336: -- l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
4337: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

Line 4334: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

4330: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
4331: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4332: LX_LINE_RELATIONSHIP_ID NUMBER;
4333: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
4334: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
4335: l_ship_id NUMBER;
4336: -- l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
4337: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
4338:

Line 5541: , P_created_by => FND_GLOBAL.USER_ID

5537: l_new_template_instance_id := NULL;
5538: ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (
5539: PX_ROWID => l_template_instance_rowid
5540: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
5541: , P_created_by => FND_GLOBAL.USER_ID
5542: , P_creation_date => SYSDATE
5543: , P_last_updated_by => FND_GLOBAL.USER_ID
5544: , P_last_update_date => SYSDATE
5545: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

Line 5543: , P_last_updated_by => FND_GLOBAL.USER_ID

5539: PX_ROWID => l_template_instance_rowid
5540: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
5541: , P_created_by => FND_GLOBAL.USER_ID
5542: , P_creation_date => SYSDATE
5543: , P_last_updated_by => FND_GLOBAL.USER_ID
5544: , P_last_update_date => SYSDATE
5545: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5546: , P_TEMPLATE_ID => template_val.template_id
5547: , P_Owner_Table_Name => 'ASO_QUOTE_LINES'

Line 5545: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

5541: , P_created_by => FND_GLOBAL.USER_ID
5542: , P_creation_date => SYSDATE
5543: , P_last_updated_by => FND_GLOBAL.USER_ID
5544: , P_last_update_date => SYSDATE
5545: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5546: , P_TEMPLATE_ID => template_val.template_id
5547: , P_Owner_Table_Name => 'ASO_QUOTE_LINES'
5548: , P_Owner_Table_Id => P_NEW_QUOTE_LINE_ID
5549: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 5583: , P_created_by => FND_GLOBAL.USER_ID

5579: , P_Template_Instance_ID => l_new_template_instance_id
5580: , p_value => inst_val.VALUE
5581: , p_value_type_qualifier => inst_val.value_type_qualifier
5582: , p_response_id => inst_val.response_id
5583: , P_created_by => FND_GLOBAL.USER_ID
5584: , P_last_updated_by => FND_GLOBAL.USER_ID
5585: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5586: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
5587: );

Line 5584: , P_last_updated_by => FND_GLOBAL.USER_ID

5580: , p_value => inst_val.VALUE
5581: , p_value_type_qualifier => inst_val.value_type_qualifier
5582: , p_response_id => inst_val.response_id
5583: , P_created_by => FND_GLOBAL.USER_ID
5584: , P_last_updated_by => FND_GLOBAL.USER_ID
5585: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5586: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
5587: );
5588: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 5585: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

5581: , p_value_type_qualifier => inst_val.value_type_qualifier
5582: , p_response_id => inst_val.response_id
5583: , P_created_by => FND_GLOBAL.USER_ID
5584: , P_last_updated_by => FND_GLOBAL.USER_ID
5585: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5586: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
5587: );
5588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5589: aso_debug_pub.ADD ( 'New Instance Value Id : ' || TO_CHAR ( l_instance_value_id ) , 1 , 'N' );

Line 5836: p_CREATED_BY => fnd_global.USER_ID,

5832:
5833: ASO_PAYMENTS_PKG.Insert_Row(
5834: px_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
5835: p_CREATION_DATE => SYSDATE,
5836: p_CREATED_BY => fnd_global.USER_ID,
5837: p_LAST_UPDATE_DATE => SYSDATE,
5838: p_LAST_UPDATED_BY => fnd_global.USER_ID,
5839: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
5840: p_REQUEST_ID => l_payment_rec.REQUEST_ID,

Line 5838: p_LAST_UPDATED_BY => fnd_global.USER_ID,

5834: px_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
5835: p_CREATION_DATE => SYSDATE,
5836: p_CREATED_BY => fnd_global.USER_ID,
5837: p_LAST_UPDATE_DATE => SYSDATE,
5838: p_LAST_UPDATED_BY => fnd_global.USER_ID,
5839: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
5840: p_REQUEST_ID => l_payment_rec.REQUEST_ID,
5841: p_PROGRAM_APPLICATION_ID => l_payment_rec.PROGRAM_APPLICATION_ID,
5842: p_PROGRAM_ID => l_payment_rec.PROGRAM_ID,

Line 5839: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

5835: p_CREATION_DATE => SYSDATE,
5836: p_CREATED_BY => fnd_global.USER_ID,
5837: p_LAST_UPDATE_DATE => SYSDATE,
5838: p_LAST_UPDATED_BY => fnd_global.USER_ID,
5839: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
5840: p_REQUEST_ID => l_payment_rec.REQUEST_ID,
5841: p_PROGRAM_APPLICATION_ID => l_payment_rec.PROGRAM_APPLICATION_ID,
5842: p_PROGRAM_ID => l_payment_rec.PROGRAM_ID,
5843: p_PROGRAM_UPDATE_DATE => l_payment_rec.PROGRAM_UPDATE_DATE,