DBA Data[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_AWARDS

Line 1430: -- gms_awards_dist_pkg.copy_adls( p_award_set_id IN NUMBER ,

1426: -- --------------------------------------------------------------------
1427: -- CALL COPY ADLS COMMON PACKAGE to copy the new ADLS
1428: -- and also update the distribution line to create a
1429: -- link between distribution line and ADLS.
1430: -- gms_awards_dist_pkg.copy_adls( p_award_set_id IN NUMBER ,
1431: -- P_NEW_AWARD_SET_ID OUT NOCOPY NUMBER,
1432: -- p_doc_type IN varchar2,
1433: -- p_dist_id IN NUMBER,
1434: -- P_INVOICE_ID IN NUMBER DEFAULT NULL,

Line 1465: gms_awards_dist_pkg.copy_adls(p_award_set_id => l_award_set_id,

1461: where award_set_id = l_award_set_id ;
1462: x_flip_adl_status := 'Y';
1463: End If;
1464:
1465: gms_awards_dist_pkg.copy_adls(p_award_set_id => l_award_set_id,
1466: P_NEW_AWARD_SET_ID => x_award_set_id, --OUT variable
1467: p_doc_type => g_document_type_tab(i),
1468: p_dist_id => g_doc_dist_id_tab(i),
1469: p_called_from => 'MISC_SYNCH_ADLS'

Line 1532: -- gms_awards_dist_pkg.copy_adls( p_award_set_id IN NUMBER ,

1528: -- --------------------------------------------------------------------
1529: -- CALL COPY ADLS COMMON PACKAGE to copy the new ADLS
1530: -- and also update the distribution line to create a
1531: -- link between distribution line and ADLS.
1532: -- gms_awards_dist_pkg.copy_adls( p_award_set_id IN NUMBER ,
1533: -- P_NEW_AWARD_SET_ID OUT NOCOPY NUMBER,
1534: -- p_doc_type IN varchar2,
1535: -- p_dist_id IN NUMBER,
1536: -- P_INVOICE_ID IN NUMBER DEFAULT NULL,

Line 1568: gms_awards_dist_pkg.copy_adls (

1564: ( l_adl_document_type = 'APD')
1565: ))
1566: THEN
1567:
1568: gms_awards_dist_pkg.copy_adls (
1569: p_award_set_id => l_award_set_id,
1570: P_NEW_AWARD_SET_ID => x_award_set_id,
1571: p_doc_type => 'AP',
1572: p_dist_id => g_doc_dist_id_tab(i),

Line 1608: x_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;

1604: x_rec.invoice_id := g_doc_header_id_tab(i);
1605: x_rec.invoice_distribution_id := g_doc_dist_id_tab(i);
1606: x_rec.distribution_line_number := g_doc_dist_line_num_tab(i);
1607: x_rec.adl_line_num := 1;
1608: x_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
1609:
1610: gms_awards_dist_pkg.create_adls (x_rec);
1611:
1612: UPDATE ap_invoice_distributions_all

Line 1610: gms_awards_dist_pkg.create_adls (x_rec);

1606: x_rec.distribution_line_number := g_doc_dist_line_num_tab(i);
1607: x_rec.adl_line_num := 1;
1608: x_rec.award_set_id := gms_awards_dist_pkg.get_award_set_id;
1609:
1610: gms_awards_dist_pkg.create_adls (x_rec);
1611:
1612: UPDATE ap_invoice_distributions_all
1613: SET award_id = x_rec.award_set_id
1614: WHERE invoice_id = g_doc_header_id_tab(i)

Line 2947: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling gms_awards_dist_pkg.create_adls to create dummy ADL','C');

2943: x_adl_rec.last_update_login := 0;
2944: x_adl_rec.request_id := -9999;
2945:
2946: IF g_debug = 'Y' THEN
2947: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling gms_awards_dist_pkg.create_adls to create dummy ADL','C');
2948: END IF;
2949:
2950: gms_awards_dist_pkg.create_adls (x_adl_rec);
2951:

Line 2950: gms_awards_dist_pkg.create_adls (x_adl_rec);

2946: IF g_debug = 'Y' THEN
2947: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling gms_awards_dist_pkg.create_adls to create dummy ADL','C');
2948: END IF;
2949:
2950: gms_awards_dist_pkg.create_adls (x_adl_rec);
2951:
2952: END IF;
2953: l_counter := g_doc_dist_id_tab.count;
2954: --Below loop is to fetch additional information for each distribution

Line 3532: FROM gms_budget_versions pb, pa_budget_entry_methods pbm, gms_awards ga

3528: x_boundary_code,
3529: x_time_phased_type_code,
3530: x_categorization_code,
3531: x_resource_list_id
3532: FROM gms_budget_versions pb, pa_budget_entry_methods pbm, gms_awards ga
3533: WHERE ga.award_id = pb.award_id
3534: AND pb.project_id = x_project_id
3535: AND pb.award_id = x_award_id
3536: AND pb.budget_entry_method_code = pbm.budget_entry_method_code

Line 4098: x_amount_type IN gms_awards.amount_type%TYPE,

4094: x_award_id IN gms_bc_packets.award_id%TYPE,
4095: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
4096: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
4097: x_expenditure_item_date IN DATE,
4098: x_amount_type IN gms_awards.amount_type%TYPE,
4099: x_boundary_code IN gms_awards.boundary_code%TYPE,
4100: x_set_of_books_id IN gms_bc_packets.set_of_books_id%TYPE,
4101:
4102: -- x_budgeted_task_id IN gms_bc_packets.bud_task_id%TYPE,

Line 4099: x_boundary_code IN gms_awards.boundary_code%TYPE,

4095: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
4096: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
4097: x_expenditure_item_date IN DATE,
4098: x_amount_type IN gms_awards.amount_type%TYPE,
4099: x_boundary_code IN gms_awards.boundary_code%TYPE,
4100: x_set_of_books_id IN gms_bc_packets.set_of_books_id%TYPE,
4101:
4102: -- x_budgeted_task_id IN gms_bc_packets.bud_task_id%TYPE,
4103: -- x_bud_res_list_member_id IN NUMBER,